select employeeid, lastname, firstname,title FROM Employees
where employeeid=7



select employeeid, lastname, firstname,city FROM Employees
where country="Usa"


select orderid, customerid, orderdate from Orders where orderdate<'1996-10-25'




select companyname from Customers where country='France'or country='Spain';
select productname, unitprice from Products where unitprice>20 and unitprice<30;
select productname, unitprice from Products;
select categoryid, categoryname from Categories where categoryname='seafood';
select productname, unitprice from Products;
select supplierid from Suppliers where companyname='Tokyo Traders';
select productname, unitsinstock from Products where supplierid=4;
select productname from Products where unitsinstock=0;



select productname,unitprice, categoryid from Products where productname like'T%'and unitprice>15 or categoryid=4 and unitprice>15

select productname,unitprice, categoryid from Products where productname like'T%'and unitprice>15 or categoryid=4 and unitprice>15;
select productname, unitprice from Products where unitprice Between 10 and 20;
select productname, unitprice from Products where unitprice<10 or unitprice>20;
select companyname, country from Suppliers where country in ('Japan','Italy');
select companyname, phone,contacttitle from Suppliers where fax is null;
select orderid, orderdate,customerid from Orders where shippeddate is null and shipcountry='Argentina'