mysql每个管理者下的员工_MySQL练习 显示没有经理的所有员工的全名

1、Displaythefullnameofallemployeeswithnomanager.2、Displaytheproductnameforproductsthathave“ski”inthename.3、Foreachemployee,calculatethenumberofmonthsbetweentodayandt...

1、Display the full name of all employees with no manager.

2、Display the product name for products that have “ski” in the name.

3、For each employee, calculate the number of months between today and the date the employee was hired. Order your result by the number of months employed.Round the number of months up to the closest whole number.

4、Display the product name, product number, and quantity ordered of all items in

order number 101. Label the quantity column ORDERED.

5、Display all customers and the product number and quantities they ordered for

those customers whose order totaled more than 100,000.

1、显示没有经理的所有员工的全名。

2、以“滑雪”的名称显示产品名称

3、对于每个雇员，计算从雇员受雇日期到今天的月份数。用所雇用的月份数来决定你的结果。

4、显示所有项目中的产品名称、产品编号和订购数量订单号101。标记订购的数量列。

5、显示所有客户和他们订购的产品数量和数量订单总数超过100000的客户

展开