Question

| Create a table salesman salesman_id, name, city, commission and customer (customer_id, name, city, grade, slaesman id;. Write the following query: ▸ Create a view for those salesmen belongs to the city New York ▸ Create a view for all salesmen with columns salesman id, name, and city ➤ Find the salesmen of the city New York who achieved the commission more than 13%. ▸ Create a view to getting a count of how many customers we have at each level of a grade.​

Answer 1

Answer:

SQL syntax:

<column_name>,[HAVING <predicate>] ] [ORDER_BY <column_name> | <column_number> [ASC | DESC],... ];

• Note: Use * to get a complete list of the columns from a table.