SQL queries on a PostgreSQL Sample Database

4 Questions with corresponding queries

Each SQL query needs to include one or more explicit JOINs. The JOIN or JOINs should be necessary to the query. Each SQL query needs to include one or more aggregations. This could be a COUNT, AVG, SUM, or other aggregation. 2 of the 4 SQL queries need to include either a subquery OR a CTE. 1 of the 4 queries should use a Window Function. The SQL queries are well formatted and use aliases.

I'll post the 4 questions.

Kemahiran: MySQL, SQL, Pentadbiran Pangkalan Data

Lihat lagi: sample reference check questions regarding website design, sample trivial pursuit questions, database exams questions, sample ecommerce project questions, sample true false questions data analysis, test paper sample true false questions, sample sql queries cricket tournament, sql server sample database migration scripts, database quiz questions answers, sample mcq exam questions aspnet, database examination questions, sample true false questions answers, introduction psychology sample multiple choice questions, multiple choice questions sql queries answer, sql queries multiple choice questions test, sample multiple choice questions sql, sql queries multiple choice questions answers, multiple choice questions sql queries answers

Tentang Majikan:
( 1 ulasan ) Calgary, Canada

ID Projek: #20865426

Dianugerahkan kepada:


Hi There I've excellent database design, SQL programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Database project according to 100% accuracy and Lagi

$50 CAD dalam sehari
(226 Ulasan)

23 pekerja bebas membida secara purata $145 untuk pekerjaan ini


Hello there, i'm expert on writing complex queries especially with JOINS and WITH statement, also the SUM, COUNT, MAX function within GROUP BY statement. Pls share me 4 questions. Waiting for your response if intereste Lagi

$250 CAD dalam 2 hari
(170 Ulasan)

Hello. How are u? Your job post caught my eye. As a fullstack web developer I have epxertise with mysql, postgreSQL and so highly skilled in create query. I am sure I could help u accordingly. I can assist u right now Lagi

$200 CAD dalam sehari
(12 Ulasan)

Hello. I read your project fully and it is possible for me. As you can see my profile, I have rich experiences in web. If you hire me, I will do my best and you will see successfully result. Please contact me and post Lagi

$100 CAD dalam 2 hari
(22 Ulasan)

Hi there, I have checked the details I have great experience with Database Administration, MySQL, SQL. Please start the chat so we can discuss this job more in detail then we will discuss the final budget, Right now I Lagi

$250 CAD dalam 7 hari
(18 Ulasan)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lagi

$250 CAD dalam 4 hari
(27 Ulasan)

Hello Hope you are doing well. I have 7 years of experience in Linux and MySQL DB management. I can handle this project. Regards VishnuLal*

$250 CAD dalam sehari
(74 Ulasan)

Hello, How are you? I have read your requirements carefully and I think I am one of the mostly proper for you. And I also have been experienced 7+ years with Web and I mastered MySQL and PostgreSQL. I can complete wit Lagi

$140 CAD dalam 7 hari
(7 Ulasan)

Hello, [login to view URL]'s Jincowboy. How are you? I'm pretty happy to bid on this interesting project. I read your description carefully and I think that I am the developer you are looking for and are suitable for this task. Lagi

$140 CAD dalam 7 hari
(21 Ulasan)

DB EXPERT bid. Please let me know. I will do within 15 mins. Hope your message. Thank you. Regards.

$70 CAD dalam sehari
(3 Ulasan)

Hi, I used postgreSQL database before. I can write all the queries. Looking forward to work with you. Regards

$50 CAD dalam 2 hari
(17 Ulasan)

Hello! I have 7+ years of experience in Database Programming and Management using SQL, MySQL, Microsoft SQL, MongoDB, PostgreSQL, Oracle. So I have enough experience and ability to complete your project. If you want, l Lagi

$120 CAD dalam sehari
(2 Ulasan)

Hello, I have read you are looking for some help regarding database, please refer to my profile and let me know how I can help you with it, feel free to discuss anything, Hopefully you will get your desired work, Tha Lagi

$50 CAD dalam 7 hari
(7 Ulasan)

Greeting!. Yours work is one of the tasks that can be done very perfectly by us. We work within your budget, Within your deadline. We are highly experienced Post Graduate Engineers, IT, ITES, Software, Infrastructure P Lagi

$30 CAD dalam 2 hari
(4 Ulasan)

Dear Client, Nice to meet you. I read your description and have interest in your job now. When I saw your project I knew it was a good fit as I do a lot of this type of work. The following is my introduction. I am a fu Lagi

$140 CAD dalam sehari
(2 Ulasan)

Hello! I am very interested in your post project. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have worked on similar projects to what you are looki Lagi

$170 CAD dalam 3 hari
(0 Ulasan)

Hi there, I am a experienced Web Developer Your project is easy one for me, I can do it soon. I am sure you will be satisfied with my work and communication Skill. I'd like to discuss in details. Many Thanks.

$30 CAD dalam sehari
(0 Ulasan)

With The Blessing & help of ALLAH ..! i have expertise in Mobile (iOS/Android) app development and Web development(PHP laravel,word opress .NET, JAVA) web app design & development mobile application development on Andr Lagi

$180 CAD dalam 3 hari
(0 Ulasan)

Hi, Thank U for Reviewing My Bid. We have 1000's of Reviews on Upwork. I am available in EST Time zone also. I have read your job description with great interest and would like to use this opportunity to apply for thi Lagi

$250 CAD dalam 7 hari
(0 Ulasan)

Hello How are you? I am very interesting about your project. I am expert web design and development in "PHP, MySQL,Wordpress, WooCommerce, Shopify, React jQuery, PSD to HTML, Psd to CMS, bootstrap, material design, HT Lagi

$130 CAD dalam 7 hari
(0 Ulasan)

I have experience with different SQL tools, including PostgreSQL. I can write complex JOINs, nested queries and almost everything for an efficient operational Database.

$200 CAD dalam sehari
(0 Ulasan)