SQL Foundations I Module 3

Use WHERE, ORDER BY, GROUP BY clauses

Only editable by group admins

  • Last updated November 13, 2017 at 4:52 PM
  • Evidence visible to public
All queries will use different predicates (WHERE clause), sort on different attributes (ORDER BY clause), and use a mix of single-row and aggregate functions. Submit a link to show your work.

All posted evidence

Links for all queries accessible through SQLFiddle

http://sqlfiddle.com/#!9/ea89d8e/1
http://sqlfiddle.com/#!9/ea89d8e/2
http://sqlfiddle.com/#!9/ea89d8e/3
http://sqlfiddle.com/#!9/ea89d8e/4
http://sqlfiddle.com/#!9/ea89d8e/5
http://sqlfiddle.com/#!9/ea89d8e/6
http://sqlfiddle.com/#!9/ea89d8e/7
http://sqlfiddle.com/#!9/ea89d8e/8
http://sqlfiddle.com/#!9/ea89d8e/9
http://sqlfiddle.com/#!9/ea89d8e/10
http://sqlfiddle.com/#!9/ea89d8e/11
mpurnell1 About 7 years ago

WHERE, ORDER BY, GROUP BY clauses.

Pastebin

SELECT title, AVG(year_released) FROM movies GROUP BY title; SELECT cre - Pastebin.com

vbecu1 About 8 years ago

Uses GROUP BY on location to count files in echo directory, uses WHERE to show only directories with more than 15 files, ORDERS BY files too

Puu

https://puu.sh/sT7XF/9bf207d5e7.png

jaco About 8 years ago

Uses GROUP BY on country to count movies from each country. Then uses ORDER BY on the new movie count.

Puu

https://puu.sh/sT5lC/7b16b33357.png

jaco About 8 years ago

Uses WHERE to filter out people who are dead and entries that don't have a surname because they were tied to someone dead. ORDER BY surname.

Puu

https://puu.sh/sT4EY/2e48c7c42a.png

jaco About 8 years ago

Uses WHERE to find only actors and then ORDERS BY movies.

Puu

https://puu.sh/sT7rr/3f9927cf4c.png

jaco About 8 years ago

Uses WHERE to filter by directors who died in 2016, uses GROUP BY name to remove duplicate credits, and ORDERS BY age.

Puu

https://puu.sh/sT66S/ee47138b69.png

jaco About 8 years ago

Kept it simple and used the Konagora DB http://edu.konagora.com/SQLsandbox.php

Pastebin

SELECT * FROM credits NATURAL JOIN movie_title_ft_index2 WHERE title_wor - Pastebin.com

Pastebin PRO Accounts CHRISTMAS SPECIAL! For a limited time only get 50% discount on a LIFETIME PRO account! Offer Ends Soon!
randyiv About 8 years ago

7. Predicates!

Hidden-shore-76374

Devblog

kfowler About 8 years ago