Đã hoàn thành

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.

Kĩ năng: MySQL, SQL, Quản trị cơ sở dữ liệu

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Calgary, Canada

ID dự án: #20865426

Được trao cho:

urmate

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 Thêm

$50 CAD trong 1 ngày
(222 Đánh Giá)
6.7

24 freelancer đang chào giá trung bình $145 cho công việc này

truongnguyen86

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 Thêm

$250 CAD trong 2 ngày
(167 Nhận xét)
6.8
grishamarkov1188

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 Thêm

$200 CAD trong 1 ngày
(12 Nhận xét)
6.1
nisharapath

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 Thêm

$100 CAD trong 2 ngày
(20 Nhận xét)
5.7
AwaisChaudhry

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 Thêm

$250 CAD trong 7 ngày
(18 Nhận xét)
5.7
schoudhary1553

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 Thêm

$250 CAD trong 4 ngày
(27 Nhận xét)
5.9
bindmission

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 trong 1 ngày
(72 Nhận xét)
5.5
KimHyokJun

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. Thêm

$140 CAD trong 7 ngày
(21 Nhận xét)
5.1
MaZheng225

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 Thêm

$140 CAD trong 7 ngày
(7 Nhận xét)
5.2
AISense

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

$70 CAD trong 1 ngày
(3 Nhận xét)
4.4
MHassanBedor

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

$50 CAD trong 2 ngày
(14 Nhận xét)
3.6
MubashirAs62

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 Thêm

$50 CAD trong 7 ngày
(7 Nhận xét)
2.8
ItManager125

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 Thêm

$120 CAD trong 1 ngày
(2 Nhận xét)
2.9
fastlabindia

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 Thêm

$30 CAD trong 2 ngày
(4 Nhận xét)
2.6
strictdeveloper

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 Thêm

$140 CAD trong 1 ngày
(2 Nhận xét)
1.2
psjahn19815

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 Thêm

$130 CAD trong 7 ngày
(0 Nhận xét)
0.0
webshsol

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 Thêm

$180 CAD trong 3 ngày
(0 Nhận xét)
0.0
ckrukp

I have just read your requirements and i am really interested in your project. I have rich experiences in this field and i can implement your requirements perfectly. I think communication is very important in business Thêm

$140 CAD trong 7 ngày
(0 Nhận xét)
0.0
vibhutitech

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 Thêm

$250 CAD trong 7 ngày
(0 Nhận xét)
0.0
draddy

Dear Sir or Madam, I hope you are doing good. I am interested in your job offer. I think your program is the best for its niche. I was awarded Computer and Systems Award for being to of my class. Relevant Skills and Thêm

$155 CAD trong 3 ngày
(0 Nhận xét)
0.0
AlexanderIProdan

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 trong 1 ngày
(0 Nhận xét)
0.0