Question

Field name Data type

Empno (p) Number

Name Text

DOB(Dt-of-birth) Date/time

Nativeplace Text

Hobby Text

Salary Number

1. Show record of those who have sports as hobby.

2. Show Name, hobby and salary in descending order of salary.

3. Show Name, DOB and nativeplace of those whose name begins with ’A’

OR ends with’d’.

4. Show those employees whose salary is more than 6000 AND name

begins with 'A'.

5. Delete those records whose hobby is music.

6. Count the total number of records.​

Answer 1

Answer:

26-Feb-2020 · SQL Subquery Exercises: Display the name, salary, department id for those employees who earn such amount of salary which is the ...