Seussology DB I

Objective

For this assignment, you will demonstrate your skills and understanding of SQL Queries by creating queries that read data from the Seussology Database.

Project Setup

1. Clone the Repository

Clone this repository from GitHub and use the provided file to complete the assignment.

2. Import the Seussology Database

To import the database, using phpMyAdmin, complete the following instructions.

Open phpMyAdmin at http://localhost/phpmyadminopen in new window(Windows) or http://phpmyadmin.testopen in new window(macOS)
Log in to phpMyAdmin using the root username and password
From the phpMyAdmin homepage, click on the "Import" tab found at the top of the page.
Under the "File to import" section, click the "Choose File" button. Choose the seussology.sql file found in this repository.
Click the "Go" button found at the bottom of the page.
Once the importing has been completed, click on the seussology database, which should appear in the list on the left side of the page.
With the seussology database selected, click on the "SQL" tab at the top of the page. From this page, you can execute custom SQL commands.

Requirements

Create ONE query for each of the 10 tasks below. The queries should be saved in the queries.sql file.

1. Retrieve all columns and rows from the `categories` table.

Results of Query 1

2. Retrieve the book title (`book_title`) with the book id (`book_id`) of 13 from the `books` table.

Results of Query 2

3. Retrieve the book title (`book_title`) and book year (`book_year`) from the `books` table with the book title (`book_title`) of "The Foot Book".

Results of Query 3

4. Retrieve the book title (`book_title`) and book year (`book_year`) from the `books` table with a book year (`book_year`) before 1950.

Results of Query 4

5. Retrieve all the book titles (`book_title`) from the `books` table with the number of pages (`book_pages`) greater than 35 and less than 56.

Results of Query 5

6. Retrieve all the book titles (`book_title`) from the `books` table that contain the word "you".

Results of Query 6

7. Retrieve all the quotes (`quote`) from the `quotes` table that start with the word "Think".

Results of Query 7

8. Retrieve the first 10 book titles (`book_title`) from the `books` table when sorted alphabetically.

Results of Query 8

9. Retrieve the next 10 book titles (`book_title`) from the `books` table when sorted alphabetically.

Results of Query 9

10. Using a subquery, retrieve all the book titles (`book_title`) and book years (`book_year`) from the `books` table that have the "Short Stories" category.

Results of Query 10

Rubric

Criteria	Pts
Successfully completed task #1 using one query	2
Successfully completed task #2 using one query	2
Successfully completed task #3 using one query	2
Successfully completed task #4 using one query	2
Successfully completed task #5 using one query	2
Successfully completed task #6 using one query	2
Successfully completed task #7 using one query	2
Successfully completed task #8 using one query	2
Successfully completed task #9 using one query	2
Successfully completed task #10 using one query	2
Total	20

# Seussology DB I

# Objective

# Project Setup

# 1. Clone the Repository

# 2. Import the Seussology Database

# Requirements

# 1. Retrieve all columns and rows from the categories table.

# 2. Retrieve the book title (book_title) with the book id (book_id) of 13 from the books table.

# 3. Retrieve the book title (book_title) and book year (book_year) from the books table with the book title (book_title) of "The Foot Book".

# 4. Retrieve the book title (book_title) and book year (book_year) from the books table with a book year (book_year) before 1950.

# 5. Retrieve all the book titles (book_title) from the books table with the number of pages (book_pages) greater than 35 and less than 56.

# 6. Retrieve all the book titles (book_title) from the books table that contain the word "you".

# 7. Retrieve all the quotes (quote) from the quotes table that start with the word "Think".

# 8. Retrieve the first 10 book titles (book_title) from the books table when sorted alphabetically.

# 9. Retrieve the next 10 book titles (book_title) from the books table when sorted alphabetically.

# 10. Using a subquery, retrieve all the book titles (book_title) and book years (book_year) from the books table that have the "Short Stories" category.

# Rubric