Scribd
Upload
20 views5 pages

SQL Assignment 2 Quiz Questions

This document contains a 20 question SQL assignment quiz. The quiz questions cover topics like finding employees by manager ID, counting employees by manager ID, finding maximum salary by department, joining employee and manager names, filtering by salary range, filtering by specific salaries, finding total salaries by department, filtering by name patterns, splitting strings, calculating name length, retrieving employee joining dates and experience, calculating gross salary, and string manipulation. The student is asked to provide their answers to each SQL query question.

Uploaded by

spillthehawttae
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
20 views5 pages

SQL Assignment 2 Quiz Questions

This document contains a 20 question SQL assignment quiz. The quiz questions cover topics like finding employees by manager ID, counting employees by manager ID, finding maximum salary by department, joining employee and manager names, filtering by salary range, filtering by specific salaries, finding total salaries by department, filtering by name patterns, splitting strings, calculating name length, retrieving employee joining dates and experience, calculating gross salary, and string manipulation. The student is asked to provide their answers to each SQL query question.

Uploaded by

spillthehawttae
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

5/1/2020 SQL - Assignment 2

SQL - Assignment 2
* Required

Email address *

Your email

Name *

Your answer

Phone *

Your answer

Quiz Questions

[Link] 1/5
5/1/2020 SQL - Assignment 2

[Link] the employees working with the manager 7698. *

Your answer

[Link] number of employees with manager 7839. *

Your answer

[Link] the details of the employee getting maximim salary in department no 30. *

Your answer

[Link] the employee name and manager name joined with '@' symbol. *

Your answer

[Link] an SQL query to find the employee no,name whose salary is in the range
of 1500 and 3000. *

Your answer

[Link] an SQL query to find the employee no,name whose salary is either 1350
or 1600 or 1800. *

Your answer

[Link] 2/5
5/1/2020 SQL - Assignment 2

[Link] the total salaries for departmentno 20. *

Your answer

[Link] the names of employees that ends with 'N'. *

Your answer

[Link] the employee names with four letters . *

Your answer

[Link] the names of employees that ends with 'S'or 'D' or 'E'. *

Your answer

[Link] the employee names containg 'll'. *

Your answer

[Link] the following statement into words.'LEARNING SQL IS FUN AND EASY'. *

Your answer

[Link] 3/5
5/1/2020 SQL - Assignment 2

[Link] the length of your name. *

Your answer

[Link] the year of joining of employees. *

Your answer

[Link] the joining year and month of employees *

Your answer

[Link] the experience of the employee in years and months. *

Your answer

[Link] the "gross salary" of employee as salary+comm. *

Your answer

[Link] 'SQL' from 'LEARNING SQL IS FUN AND EASY'. *

Your answer

[Link] 4/5
5/1/2020 SQL - Assignment 2

[Link] 'FUN AND EASY' from 'LEARNING SQL IS FUN AND EASY'. *

Your answer

[Link] the strings str1,str2,str3,str4,str5 with '$'. *

Your answer

Send me a copy of my responses.

Submit

Never submit passwords through Google Forms.

reCAPTCHA
Privacy Terms

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

 Forms

[Link] 5/5

You might also like