Homework (100 points)
Create the desks from demonstration. sql software
Copy the trial. sql file from the Doctor Share towards the C: \temp directory. On the sql fast enter the order @V: \temp\demo. sql. This will likely create some tables and insert data into these people. View the script in notepad to determine the table names that have been created. Make use of the describe command to view the structure in the tables. Please use the design below to provide your solutions. Write SQL statements to solve the following asks for.
Question (4 pts per question) | SQL declaration or answer| 1 . List all staff information in department 35. | CHOOSE * FROM emp EXACTLY WHERE deptno = 30; | 2 . List employees term, job, and salary that is a manager and has a salary > $1, 000| CHOOSE ename, job, sal FROM emp WHERE sal > 1000 AND job = 'MANAGER'; | 3. Do it again exercise two for any staff that is not a manager or earns an income > $1, 000| SELECT ename, work, sal BY emp IN WHICH sal > 1000 AND job! sama dengan 'MANAGER'; | 4. Display all staff names and salary that earn between $1, 1000 anod $2, 000. Utilize between operator. | CHOOSE ename, garbo FROM emp WHERE desenfado between a thousand and 2k; | 5. Select all employees that are in section 10 and 30. Make use of the IN owner. | SELECT * VIA EMP WHERE DEPTNO IN (10, 30); | 6th. Select every employee titles with an " AвЂќ in the first position in the employee brand. Use the substring function or a wild cards. | CHOOSE * VIA EMP WHEREVER ENAME JUST LIKE 'A%'; | 7. Choose all staff with an " AвЂќ as the second character of their name. Use a wildcard. | SELECT * FROM EMP WHERE ENAME LIKE 'A%'; | almost 8. List automobile names in alphabetical series. | CHOOSE ENAME VIA EMP ORDER BY ENAME ASC; | 9. List the job, earnings, and staff name in job order and then wage in climbing down order. | SELECT work, sal, ename FROM emp ORDER SIMPLY BY JOB, DESENFADO DESC; | 10. Present a list of several jobs. Remove repeating ideals. | CHOOSE DISTINCT task FROM...