For SQL Database Develpoment For this query you will need to

For SQL Database Develpoment

For this query, you will need to copy and paste, or upload your sql query that will solve this question.

1.Make sure you put the USE command on the first line to show what database is used.

2.An SQL comment with your name, quiz number and question number.

3.The complete SQL statement

Query #1: The Human resources department has asked you to create a report for them that will list selected employee information. In the report, they need the employee identification number, Employee first and last name, and their current title. Please sort the output by employee identification number, making sure the highest number is first on the list.

Solution

I don\'t know, what data base you are using and table schema. So i have written the skelton of query. What you need to do is just change the database_name, table_name and the selected column names from your schema.

Please give thumps up to my answer, if you like my efforts.

USE database_name;

/*
Name:
Quiz number:
Question number:
*/

SELECT emp_id,first_name,last_name,title
FROM table_name
ORDER BY emp_id DESC;