Database management systems

download practical 2 question

select *
from customer;


--Q2
select fname,lname
from customer
where state='FL';


--Q3
select address1,address2
from customer
where customer_num='16';


--Q4
select fname,lname
from customer
where state='CA' and city like 'Redwood%';


--Q5
select *
from manufact
where manu_code='NRG';


--Q6
select *
from stock;


select unit_price,description,manu_code
from stock
where manu_code='HRO' or manu_code= 'HSK';


--Q7
select *
from orders;


--Q8
select *
from stock
where unit_price between 100 and 250;


--Q9
select customer_num,fname,lname
from customer
where city is NULL;


--Q10
select *
from orders
where backlog is NULL;


--Q11
select *
from orders
where order_num in (5, 8 ,10);


--Q12
select fname,lname,city,phone
from customer
where state in ('FL','NJ','NY','MA');


--Q13
select *
from manufact
where manu_code like 'H%';


--Q14
select *
from manufact
where manu_name like '[A-N]%';


--Q15
select fname,lname
from customer
where lname like '[D-H]%' or 'R%'