Day 8 learn how to filter tables within a database using SQL. Filter based on one condition, or two or more conditions. Learn logical operators such as AND, OR, NOT and comparison operators (greater than, less than, etc.) to filter data. Use the IN keyword to pass a list of values in the WHERE clause and the LIKE operator to match text patterns (similar to regular expressions).
Video Questions:
/*Question 1
Filter for all customers
in Prague*/
/*Question 2
Filter for all customers in
Prague or New York*/
/*Question 3
Filter for all customers who
do not have a missing Fax number */
/*Question 4
Filter for customers in the following
states: NY, CA, WI, TX */
/*Question 5
Filter for customers who have
the word 'yahoo' anywhere in their email*/
Take Home Practice Questions:
/*Take home practice using 'invoices' table
1. Filter for total bills more than 10.00
2. Filter for customers in USA or Canada
3. Filter for all addresses that may contain 'Street'*/
-----------------------------------------------------------------
Download SQLite Studio Here: sqlitestudio.pl/
Download the Chinook Database: www.sqlitetuto...
Link to Topic List: docs.google.co...
Link to Facebook Support Group: / 767988395118964
Link to my Data Etsy Shop (support me to keep making content): jellysgeekygoo...
Buy me a coffee to show support: buymeacoffee.c...
#sql #sqltutorial #sqlforbeginners
29 сен 2024
