- Run the query in the editor. Which column does the error name?
- Fix it: show each
countryand the number of customers from it. - Show each order
statusand the number of orders with it. Most orders first; when two counts are the same, sort by status from A to Z. - Show each
category_idand the total stock of the products in it. Look for the group of the product with no category. - Show each
department_idand the average salary of its employees, rounded to 2 decimal places.