Sentencias de SQL

Sentencias de SQL

1.- Select * from orders
Where month (orderdate) = 07 an year (orderdate) = 1996

2.- Select count (orderid) as [total de compras]

From orders inner join customers on orders

Customerid = customers.customerid

Where contactname = ' antonio moreno'

3.- Select products.productname

From products, [order details], orders

Where (orders.orderid = [order details].orderid and products.productid = [order details].productid) and month (orders.ordedate) = 03 and year (orders.orderdate) = 1998

4.- Selec [order details] - orderir, products.productname

From products, [order details]

Where products.productid = [order details]. productid order by [order details].orderid