In this project we're going to:

• Import a prepopulated database into MySQL called sakila
• Write SQL to view and query data from the database
• Write SQL to insert, update and delete records in the database.

Make sure you have checked off the following tasks:

• Download and install MySQL Community Edition and MySQL Workbench
• Read as much of this documentation as you can. It describes a prepopulated database called sakila that we will use as the basis for these SQL exercises.
• Follow these instructions to load a sample database called sakila into your MySQL server.

1. Initialize the Project
2. Review the Project Files
3. Start the first exercise
4. Complete the subsequent exercises

First, we need to perform the usual, repeatable steps to start a new project. Clone the project from github and start working through the steps below.

You will also need to add the following file to the root of your project - replacing the values in this file with your MySQL username/password.

config.js

module.exports = {
    username: 'your_mysql_username',
    password: 'your_mysql_password'
};

Next, review the files that you have been provided. You will notice we have provided 9 exercises in ./sql/exercises.sql for you to complete and a spec file containing tests. It is recommended that you use MySQL Workbench to test out your queries and visually check your work, then paste your solution in the correct .sql file followed by npm run test.

Open sql/exercises.sql and enter the following answers for the first three select questions:

#                              __
# .--------.--.--.-----.-----.|  |
# |        |  |  |__ --|  _  ||  |
# |__|__|__|___  |_____|__   ||__|
#          |_____|        |__|
#

# Important: Remember to add a semi-colon at the end of each query.

# ---------------------------------------------------------#

## 1. SELECT statements

# 1a. Select all columns from the actor table.
SELECT * FROM actor;

# 1b. Select only the last_name column from the actor table.
SELECT last_name FROM actor;

# 1c. Select only the following columns from the film table.
#
# COLUMN NAME           Note
# title                 Exists in film table.
# description           Exists in film table.
# rental_duration       Exists in film table.
# rental_rate           Exists in film table.
# total_rental_cost     rental_duration * rental_rate
SELECT
    title, 
    description, 
    rental_duration, 
    rental_rate, 
    rental_duration * rental_rate as total_rental_cost
FROM film;

Now, open a terminal and run the tests. The first three tests under SELECT should pass once you add the above code.

Now it's your turn. Utilize your resources and knowledge of SQL to complete the rest of the exercises.

• All exercises should pass their associated test.
• Added a README.md to the root of the project
• Upload the project to GitHub

There is no need to publish this to now.sh and you can provide the github url only for this project submission. Submit your project

#Thank you for taking the time to look at my projects,

#Also please follow my progress on youtube: https://www.youtube.com/channel/UCXv4p-lDYeWXPlnoRFYCSUg