A Tour of SQL
Lesson 5: Where conditions
We start again with the table tbl_customers that has the following structure:

customer_id (number)
first_name (string)
last_name (string)

You can apply where conditions as well on string fields. In the right table you can see one example query. Trying changing the query to output only datasets with last_name = 'Taylor'.

Can you also change the query to output only datasets with last_name = 'Taylor' and first_name = 'Andreas' (just combine the where conditions with and) ?

   
 

select customer_id, first_name, last_name from tbl_customers where last_name = 'Miller';






 
 
             



Share