SQL Queries
use sql_store; select * from customers; select state,first_name,last_name from customers where customer_id=1; select state,first_name,last_name from customers where state='AP'; select state,first_name,last_name from customers where state like '%A'; select state,first_name,last_name from customers -- where state like '%A' order by first_name; select * from customers where customer_id=1; select * from customers -- where customer_id=1 order by first_name; select first_name,state,points from customers; select first_name,state,points,points+100 from customers; select first_name,state,points,points+100 as Points_increment from customers; select distinct state from customers; select * from customers where points>1000; select * from customers where state<>'VA'; select * from customers where state<>'VA' and last_name like '%y'; select * from products; select name,unit_price from products; select name,unit_price,unit_price*2 as new_u...