All questions from SQLZOO
Screen Capture results and save in a PDF or DOC file. Submit assignment on Blackboard.
All screen shots should be upright in orientation and the questions should be answered in order.
NOTE: You are encouraged to HELP each other on SLACK! Do not share screen shots but, assist each other on how to complete this assignment. Ask each other for help in the Questions and Answers channel.
Complete the following section:
Some simple queries to get you started
Some pattern matching queries
In which we query the World country profile table.
Additional practice of the basic features using a table of Nobel Prize winners.
In which we form queries using other queries.
5 SUM and COUNT (Also complete more the same)
In which we apply aggregate functions. more the same
6 JOIN (also complete music tutorial)
In which we join two tables; game and goals. previously music tutorial
In which we join actors to movies in the Movie Database.
8 Using Null(also complete Scottish Parliament)
In which we look at teachers in departments. previously Scottish Parliament
In which we look at a survey and deal with some more complex calculations.
In which we examine UK general election results.
In which we measure the impact of COVID-19
