http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
Perform following queries:
-
The list of
ContactNameof tableCustomer. -
The list of
ProductNamethat have1asCaterogyIDof tableProduct. -
In the
Producttable, instead of theID(forCategoryIDandSupplierID), 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?
