BNew Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database X Close Database Database Structure Browse Data Edit Pragmas Execute SQL Table: ENROLLMENT a Fiter in any column StudentID CourselID Grade Filter Filter Filter 1 100001 10001 A 2 10003 NULL 100001 3 100001 10004 A 100002 10006 NULL 5 100002 10004 B 6. 100002 10005 B 7 100003 10004 NULL 8 100004 10002 A 9. 100004 10003 B 10 100004 10005 NULL

C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…

Determine the kind of books in the library's current collection. Each category should include just a single entry.

5. Display the current day of the week, hour, minutes, and seconds of the current date settingon the computer you’re using. SQL commands

Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors' telephone number and address On this day in the suburbs of the city

List the names of all customers that have a credit limit of $7,500 or less

List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.

If a column value is NULL, would you consider the column to be 0 or blank (" ")?

Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)

Select "Patent Number Search" for patents. Give the title or brief description for each of the following patents, identify when they will expire, and provide the due dates for any maintenance payments related to the patents. a. Utility Patent No. 9,089, 123. p. Design Patent No. D488,590 E. Plant Patent No. 12, 144 d. Reissue Patent No. 42,997