http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
Perform following queries:
-
The list of
ContactName
of tableCustomer
. -
The list of
ProductName
that have1
asCaterogyID
of tableProduct
. -
In the
Product
table, instead of theID
(forCategoryID
andSupplierID
), display the names of categories and suppliers, all that in a single request. -
Create a user table similar to what we can find in a social network. Think about the fields required and the structure.
-
Which fields will be repeated? Is it possible to generate tables as
1,n
. And / Or what am I asking you to do?