xingyu的博客

Retrieve data from tablesWrite a SQL statement to display all the information of all salesmen.SELECT * FROM salesman;Write a SQL statement to display a string “This is SQL Exercise, Practice and S...

Write a query to display all customers with a grade above 100.SELECT * FROM customer WHERE grade>100;Write a query statement to display all customers in New York who have a grade value above 100...

下划线_: 通配符/占位符，匹配单个字符ESCAPE：需要查询特殊字符时，使用ESCAPE进行转义语法：WHERE ColumnA LIKE ‘%5/%%’ ESCAPE ‘/’Write a SQL statement to find those salesmen with all information who come from the city either...

Write a SQL statement to find the total purchase amount of all orders.SELECT SUM(purch_amt)FROM orders;Write a SQL statement to find the average purchase amount of all orders.SELECT AVG(purch_amt...

Write a SQL statement to display the commission with the percent sign ( % ) with salesman ID, name and city columns for all the salesmen.疑问：题目的意思应该是，输出数据时将commission的值转化为百分比值网站给出的标准答案并没有实现此功能---...

Write a query to find those customers with their name and those salesmen with their name and city who lives in the same city.SELECT customer.cust_name, salesman.name, customer.cityFROM customerJOIN...