Chapter 2, Problem 6EYW

Which of the following format elements causes months to be displayed as a three-letter abbreviation? (refer to the tables in the JustLee Books database.)a. MMMb. MONTHc. MONd. none of the above

Retrieve the employee_id, First_name, Last Name as Full Name, and net salary (salary + commission) of all employees that first_name start with character 'A' and consists of 4 characters?

you are supposed to create an excel sheet for student grade sheet. There must be at least 10 records. Following columns will be needed for the sheet.       Also add summary of the grades as follows. Grade Count A 6 B 4 C 8 D 2 F 10 TOTAL 30   Grading Criteria to calculate grades is as follows: Marks Grade 90-100 A 80-89 A- 75-79 B+ 70-74 B 65-69 C+ 60-64 C 50-59 D Less than 50 F

file / directory attribute contains the date of modification performed.

he Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.

10

SQL

Database  Q1: Which one of the following INSERT statements will successfully insert a single row? The following table has been created: CREATE TABLE student_table ( stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ; a) INSERT VALUES INTO student_table (143354, ‘Roberts’, ‘Cameron’, 6543); b) INSERT INTO student_table COLMUNS (stud_id, last_name, lunch_num) VALUES (143352, ‘Roberts’, 5543, ‘Cameron’); c) INSERT TO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352, 6543, ‘Cameron’, ‘Roberts’); d) INSERT INTO student_table VALUES (143354, ‘Roberts’, ‘Cameron’, 6543); Q2: What does the following SQL statement display: SELECT EMP_ID, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY > (SELECT MIN (E. SALARY) FROM EMPLOYEES E) ORDER BY SALARY DESC; a) Employees information who earn less money than the maximum salary b) Employees information who earn more money than the highest employee salary c) Employees information who earn…

Please explain the purpose of the GROUPING SETS clause, paying particular attention to its primary use.