Debug this query The Query written in the console is trying to insert data to the table employee. De

help
,
1

My issue

MAX() and MIN()
The MAX() and MIN() functions retrieve the maximum and minimum values from a column, correspondingly.

Below is the query to find the highest and lowest age of the customers from the table customer

SELECT MAX(Age)
FROM customer;
SELECT MIN(Age)
FROM customer;
Task
Write a query to find the highest and lowest ‘Hourly_pay’ of the employees from the table ‘employee’.

Rename the column header for highest pay as ‘max_pay’
Rename the column header for lowest pay as ‘min_pay’
Expected output
┌─────────┐
│ max_pay │
├─────────┤
│ 55 │
└─────────┘
┌─────────┐
│ min_pay │
├─────────┤
│ 28 │
└─────────┘

My code

/*Write a query to find the highest and lowest 'Hourly_pay' of the employees from the table 'employee'*/
SELECT MAX(Hourly_pay) AS max_pay
FROM employee;

Learning course: Database management systems
Problem Link: MAX() and MIN() in Database management systems