CSCI 466 Assignment 6
SQL - DML - Single Table (100pts)
Introduction
You will be writing another SQL script. The script should work with the BabyName database, so it will need
the appropriate USE statement. Test each of the SQL statements required for the below, and then put them
into the script, making sure to comment each one. Include your name, zid, and section in each of the files
you submit.
This is a fairly large database, so it is recommended that you add LIMIT 50 to your SQL statements when
testing, to prevent a nigh-neverending cascade of text from needing to be downloaded.
Your script must do each of the following:
1. Select the BabyName database.
2. Show all of the tables in the database.
3. Show all of the columns and their types for each table in the database.
4. Show all of the years (once only) where your first name appears. Some people’s names may not be
present in the database. If your name is one of those, then use ‘Chad’ if you are male, or ‘Stacy’ if you
are female. If you don’t feel you fit into one of those, feel free to use ‘Pat’.
5. Show all of the names from your birth year. (Showing each name only once.)
6. Display the most popular male and female names from the year of your birth.
7. Show all the information available about names similar to your name (or the one you adopted from
above), sorted in alphabetical order by name, then, within that, by count, and finally, by the year.
8. Show how many rows there are in the table.
9. Show how many names there were in the year 1972.
10. Show how many names are in the table for each sex from the year 1953.
11. List how many different names there are for each place.
What to turn in?
Submit, through Blackboard, the following:
1. The SQL script that accomplishes the above task.
2. The output yielded by having MariaDB run the script, in a text file.
