Hi, I hope you are well. In this lab we will even different type of database query for you exercise well and understand the language Transact SQL.
Note:
This lab is tested under the Database Management System (DBMS) MySQL.
Do not forget to leave me a comment ;) Thanks
these are the queries:
1.Create the database «command_management».
2.Create the tables with Data integrity.
3.Insert the data in the tables.
4.Add the column "postal_code" type «bigint» in the customer table.
5.Change the column type «postal_code» of type «int».
6.Delete the column «postal_code».
7.Change the city of the customer (customer number = 110); Now he lives in the «Dallas».
8.List of all customers.
9.customers List live in «New York».
10.Number of customers by city.
11.First and last name customer, combined in a column named «Full Name».
12.Customers List with the name that contains the letter «a».
13.Customers List with name beginning with «a».
14.List of customers sorted by last_name.Ascending
15.List of clients aged over 40 years.
16.The number of customers in our database.
17.List of command in the month of December.
18.List of command past between 2016/01/01 and 2016/11/20.
19.The first command.
20.Client List did not past command.
21.List of customers who past command.
22.customer past command with the number of command.
23.Customer who past an command that contains the highest quantity.
24.Create a view that displays the total price of all command.
25.Create a view that displays the price controls of the month of January.
see also
The technical language Transact SQL (MySQL) :
https://www.amazon.com/dp/B01LDB3934
Note:
This lab is tested under the Database Management System (DBMS) MySQL.
Do not forget to leave me a comment ;) Thanks
these are the queries:
1.Create the database «command_management».
2.Create the tables with Data integrity.
3.Insert the data in the tables.
4.Add the column "postal_code" type «bigint» in the customer table.
5.Change the column type «postal_code» of type «int».
6.Delete the column «postal_code».
7.Change the city of the customer (customer number = 110); Now he lives in the «Dallas».
8.List of all customers.
9.customers List live in «New York».
10.Number of customers by city.
11.First and last name customer, combined in a column named «Full Name».
12.Customers List with the name that contains the letter «a».
13.Customers List with name beginning with «a».
14.List of customers sorted by last_name.Ascending
15.List of clients aged over 40 years.
16.The number of customers in our database.
17.List of command in the month of December.
18.List of command past between 2016/01/01 and 2016/11/20.
19.The first command.
20.Client List did not past command.
21.List of customers who past command.
22.customer past command with the number of command.
23.Customer who past an command that contains the highest quantity.
24.Create a view that displays the total price of all command.
25.Create a view that displays the price controls of the month of January.
see also
The technical language Transact SQL (MySQL) :
https://www.amazon.com/dp/B01LDB3934
