Duration: 60 mins 4. Write a query to display the teacher ID and last name from Teachers table where the salary between 5000 and 7000. 5. What is the expected outcome of executing the provided SQL query (show the results)? SELECT FirstName, LastName LENGTH(LastName) AS LastNameLength FROM Teachers; 6. Write a query to retrieve the details of a teacher who has the minimum salary across all departments by using the MIN operator and subqueries. 7. Write a query that displays the FirstName, and LastName columns.converting all values to lowercase in the "FirstName" column, and aliases (renaming) the column as 'lower __ case'.

Question

Duration: 60 mins 4. Write a query to display the teacher ID and last name from Teachers table where the salary between 5000 and 7000. 5. What is the expected outcome of executing the provided SQL query (show the results)? SELECT FirstName, LastName LENGTH(LastName) AS LastNameLength FROM Teachers; 6. Write a query to retrieve the details of a teacher who has the minimum salary across all departments by using the MIN operator and subqueries. 7. Write a query that displays the FirstName, and LastName columns.converting all values to lowercase in the "FirstName" column, and aliases (renaming) the column as 'lower __ case'.

Answer 1

4. SELECT teacher_id, last_name FROM Teachers WHERE salary BETWEEN 5000 AND 7000;5. The provided SQL query will display the FirstName and LastName of all teachers from the Teachers table. Additionally, it will calculate and display the length of the LastName for each teacher.6. SELECT teacher_id, first_name, last_name, salary WHERE salary = (SELECT MIN(salary) FROM Teachers);7. SELECT LOWER(FirstName) AS lower_case FROM Teachers;

Soru

Çözüm

Cevap