Normally when you use Python you use in locally on your computer, but we are going to cheat are going to use a website calledpythonanywhere.com.
We are going to use this because:
- It’s free!
- It’s easy!
- It’s web based so you code from home, school or even on the beach
So if you haven’t done already, head over to Pythonanywhere.com and sign up for a free account!
A. Create a folder called sql
B. Create a folder inside that folder called chinook
This command finds out what tables the database contains
Find out what tables the database contains.
Find out what column names and types the Album table contains
SELECT * FROM table_name;
Find out what artists are in the Artist table.
SELECT column_name, another_columnn_name FROM table_name;
Create a query that lists the first name and last name of all customers in the Customer table.
SELECT * FROM table_name WHERE column_name = “search_criteria“;
Create a query that selects all rows in the Employee table where the Title is ‘Sales Support Agent’
SELECT * FROM table_name WHERE column_name > search_criteria;
Create a query that lists all rows in the PlaylistTrack table where the TrackId is greater than 3000.
Finish challenges 1 to 6