Shulou(Shulou.com)06/01 Report--

SQL database T-SQL statement query

Attach the data file of the database

The type in the query table is the fruit whose factory date is after 201-04-01.

Query the total cost of all categories

Query the cost of the fruit in the table in reverse order

The query type is vegetable and the price is between 1 and 5.

Save the data of the name, category, and factory date in the product table in another table called product_new, and view

Query the name, category, cost, place of sale, and price of the product in the products and sales tables.

Query the product name, category, cost and sales price sold to Hainan in products table and sales table.

The query age is more than 35, less than 50, and the position is an employee?

Check the average age of employees?

Check the average age of each position and sort it in descending order according to the average age of each position.

Who is the oldest and youngest person?

How many people are there in each position? And sort by the number of people in each position in ascending order?

Ask who are older than or equal to 50 years old and less than 30 years old?

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.