select cname from client_saurabh
  select descript from product_saurabh
  select cname,city from client_saurabh
  select cname from client_saurabh where cname like '_a%'
  select city from client_saurabh where city like '_a%'
  select cname from client_saurabh where city in('Bombay','Madras','Delhi')
  select cname from client_saurabh where city = 'Bombay'
  select cname from client_saurabh where bal_due>10000
  select * from client_master
  select * from sales_order_saurabh where month(s_order_date)=1
  select * from sales_order_saurabh where client_no in ('C00001','C00002')
  select descript from product_saurabh where descript in('1.44 Drive','1.22 Drive')
  select descript from product_saurabh where sell_price between 2000 and 5000
  select sell_price,(sell_price*15) from product_saurabh where sell_price>1500
  select (sell_price*15) as 'new_price' from product_saurabh
  select * from product_saurabh
  select descript from product_saurabh where cost_price<1500
  select descript from product_saurabh  order by descript
  select sqrt(sell_price),sqrt(cost_price) from product_master
  select (cost_price/(sell_price-100))from product_saurabh where descript='540 HDD'
  select cname,city from client_saurabh where not state = 'Maharashtra'
  select product_no,descript,sell_price from product_saurabh where descript like 'M%'
  select * from sales_order_saurabh where order_status='Canceled' and month(s_order_date)=1
  select count(s_order_no) from sales_order_saurabh 
  select avg(sell_price),avg(cost_price) from product_saurabh
  select min(sell_price),min(cost_price) from product_saurabh
  select min(sell_price) as 'min_sell_price',max(sell_price) as 'max_cost_price',min(cost_price) as 'min_cost_price',max(cost_price) as 'max_cost_price' from product_saurabh 
  select count(product_no) from product_saurabh where sell_price>=1500
  select count(product_no) from product_saurabh where cost_price>=1500
  select descript from product_saurabh where qty_on_hand < reorder_lvl
  select client_saurabh.cname as 'cust_name has placed order', sales_order_saurabh.s_order_no as 'order_no', sales_order_saurabh.s_order_date as 'on  s_order_date' from client_saurabh,sales_order_saurabh
  select product_saurabh.descript,product_saurabh.product_no,sales_order_details_saurabh.product_no,sum(sales_order_details_saurabh.qty_disp) from product_saurabh,sales_order_details_saurabh group by product_saurabh.product_no,product_saurabh.descript,sales_order_details_saurabh.product_no having product_saurabh.product_no = sales_order_details_saurabh.product_no 
 sp_help sales_order_saurabh

    Source: geocities.com/zizu_sucko/Khushboo

               ( geocities.com/zizu_sucko)