Introduction to SQL

    select [table.]column_name, [... ]
      from {table }{, table }[... ]
      [where search_conditions ]

Example:
    List the stores and the quantity each has ordered of each book

    select store.store_id, stor_name, title_id, qty
           from sales_detail, stores
           where salesdetail.stor_id = stores.stor_id

    select titles.title_id, qty, price, total_price = price * qty
           from titles, sales_detail
           where titles.titles.id = sales_detail.titles_id
           order by price * qty

    select stor_name, salesdetail.stor_id, sum(qty)
           from sales_detail, stores
           where sales_detail.stor_id = stores.stor_id
           group by stor_name, salesdetail.stor_id

    select pub_name, title_id
           from titles t, publishers p
           where t.pub_id = p.pub_id
           and price = $19.99

    select stor_name, title
           from stores s, salesdetail sd, titles t
           where s.stor_id = sd.stor_id
           and sd.title_id = t.title_id