SELECT MIN(HIRE_DATE) FROM FACULTY

Consider the following SQL query: SELECT name FROM Customers WHERE date_registered > (SELECT MIN(date_registered) FROM Customers);OptionsThe names of customers who registered after the first registered customer. The names of customers who registered on the same date as the first registered customer.An error because the subquery returns multiple values.An error because the subquery is missing the FROM clause.

Select the correct answerConsider the following SQL query: SELECT name FROM Customers WHERE date_registered > (SELECT MIN(date_registered) FROM Customers);OptionsThe names of customers who registered after the first registered customer.An error because the subquery returns multiple values.An error because the subquery is missing the FROM clause. The names of customers who registered on the same date as the first registered customer.

How do you retrieve the youngest employee's name and age? *SELECT Name, Age FROM Employees ORDER BY Age ASC LIMIT 1;SELECT MIN(Age), Name FROM Employees;SELECT LAST(Name), Age FROM Employees ORDER BY Age DESC;SELECT Name, Age FROM Employees WHERE Age = MIN(Age);

INSERT INTO Employees (ID, Name, Age, Department)VALUES (1, 'John Doe', 30, 'HR'), (2, 'Jane Smith', 28, 'Finance'), (3, 'Michael Johnson', 35, 'IT'), (4, 'Emily Williams', 32, 'Sales'), (5, 'Robert Brown', 27, 'Marketing');SELECT Name, Age FROM Employees ORDER BY Age ASC LIMIT 1;SELECT MIN(Age), Name FROM Employees;SELECT LAST(Name), Age FROM Employees ORDER BY Age DESC;SELECT Name, Age FROM Employees WHERE Age = MIN(Age);

he following query throws an error. Choose the correct reason for the error as given in the options. SELECT first_name, last_nameFROM employeesWHERE commission_pct = (SELECT min(commission_pct ) FROM employees GROUP BY department_id); A. The GROUP BY clause is not required in the sub-queryB. A function cannot be used in a sub-query SELECT statementC. The single row sub-query gives multiple records