SQL Exercises: Find the highest grade for each of the cities of the customers

Last update on May 30 2022 07:23:32 (UTC/GMT +8 hours)

SQL Aggregate Functions: Exercise-8 with Solution

From the following table, write a SQL query to find the highest grade of the customers in each city. Return city, maximum grade.

Sample table: customer

Sample Solution:

SELECT city,MAX(grade) 
FROM customer 
GROUP BY city;

Output of the Query:

city		max
London		300
Paris		300
New York	200
California	200
Berlin		100
Moscow		200

Relational Algebra Expression:

Relational Algebra Tree:

Explanation:

Pictorial presentation :

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find the minimum purchase amount.
Next: From the following table, write a SQL query to find the highest purchase amount ordered by each customer. Return customer ID, maximum purchase amount.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

SQL Server SELECT into existing table.

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3