Use the query box below to answer the questions, saving your query for each question. When you are done, submit your exam for grading. establishment license_no Ko dba_name aka_name facility_type risk_level address city state zip latitude longitude employee employee_id- first_name last_name address city state zip phone title salary supervisor violation inspection_id point_id fine inspector_comment inspection inspection_id inspection_date inspection_type results employee_id license_no followup_to inspection_point point_id Description category code fine point_level vo List the inspections (inspection_id) with their date and type for all inspections that had a violation in the category of personnel' for January 2016. Also print the description of the inspection_point that was violated.

Use the query box below to answer the questions, saving your query for each question. When you are done, submit your exam for grading. establishment license_no Ko dba_name aka_name facility_type risk_level address city state zip latitude longitude employee employee_id- first_name last_name address city state zip phone title salary supervisor violation inspection_id point_id fine inspector_comment inspection inspection_id inspection_date inspection_type results employee_id license_no followup_to inspection_point point_id Description category code fine point_level vo List the inspections (inspection_id) with their date and type for all inspections that had a violation in the category of personnel' for January 2016. Also print the description of the inspection_point that was violated.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...

See similar textbooks

Similar questions

What does the funnel symbol that appears next to a field’s name in the Query Builder dialog box indicate? The field is used in a SELECT statement’s ORDER BY clause. The field is used in a SELECT statement’s WHERE clause. The field is the primary key. The field is the foreign key.
Link of the procedure: https://www.bartleby.com/questions-and-answers/computer-engineering-question/110b20bb-9fc9-44d7-885d-c28ed9f41bf7 Using the sp_InsertTeamDetails (check link above) procedure, create a query to insert the following values into the Rugby_world_cup table. Team_id Team_name Country Tries Conversions Drop_Goals Points 10 The Brave Blossoms Japan 4 3 1 35 12 Wallabies Australia 14 7 1 93 14 Welwitschias Namibia 4 3 3 44 16 Springboks South Africa 10 5 1 78 18 The Bati Fiji 2 1 1 24
Create a query based on tblEmployee and tblPurchase using the Find Unmatched Query Wizard that lists the EmployeelDFirstName, and LastName of any employee who has not yet made a sale. Save the query as qryEmployeeNoSales and then close the query
InstructionsGiven the query below in green text, rewrite it to make it more readable and easy to maintain using your personal best practices in writing query. If you don't have any personal best practices, you may follow these simple rules to start with:Use inline comments if neededUse tabs instead of spacesIndent all sub-queriesUse "WHERE 1=1" followed by " AND ..."Split column names to new linesAdd empty lines for complex queriesDo not shorten table name aliasesUse the backtick (`) before and after table & column namesNever use wildcard (*) operator in any query as much as possible, unless it's necessaryUse uppercase letters to all sql keywordsselect e.id, concat(e.first_name, ' ', e.last_name) AS employee_full_name, e.first_name, d.id AS department_id, d.name AS last_department_name from employee e inner join ( select der.employee_id, max(der.id) AS max_id from department_employee_rel der where der.deleted_flag = 0 group by der.employee_id ) derm ON derm.employee_id = e.id inner…
The InstantRide Finance team also wants to analyze travels where more than the average discount rate is applied. They want to look for any correlation between higher discount amounts against other travel characteristics. You need to create a SELECT statement which is filtered with a subquery to calculate the AVG of the TRAVEL_DISCOUNT column.
Please use question image1 to answer image 2. Thanks
Alert dont submit AI generated answer. Now you want to focus on the summarizing data for Account Reps hired before 11/2018. Specifically, you want to calculate the total number of Account Reps. In cell J13, insert the COUNTIFS function to calculate the number of Account Reps (cell H9) in the Title column where the date in the Hire Date column was before 1/1/2018. Use relative references for the two criteria range arguments and the title criteria argument in cell H9. Type the date comparison for the second criteria argument. The next step is to calculate the total salary for Account Reps hired before 11/2018. You will use mixed references so that you can later copy the function and change the function name for other calculations. In cell H14, insert the SUMIFS function to calculate the total amount in the Salary column where the Title contains the job title criteria Account Rep (cell H9) and where the date in the Hire Date column was before 1/1/2018. Use relative references for the…
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES table that will set the commission amount to .4 whenever the department_id is 80. Test your trigger COMPLETELY for every event it is defined. (Sometimes, UPDATE statements must have UPDATE tablename on a separate line by itself to keep APEX from hanging). This should work both for new rows and existing rows that are updated. Scenerio: All employees who are in the sales department (80) will have their commission always set to .4. This trigger is to enforce this business rule automatically.
Assume you have these table CREATE TABLE Student (studid Char(9) Primary Key,FirstName Varchar2(50) NOT NULL,LastName Varchar2(50) NOT NULL,Email Varchar2(50) NOT NULL UNIQUE,PhoneNumber Number(8) NOT NULL UNIQUE,DateOfBirth Date NOT NULL,GPA Number(1,2) NOT NULL); CREATE TABLE Club (clubID Number(3) Primary Key,ClubName Varchar2(20) NOT NULL,studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid)); CREATE TABLE MemberOf (ClubID Number(3) Primary Key, Studid char(9), JoiningDate date, Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid)); CREATE TABLE Activities (Actid Number(3) Primary Key,Acdt DATE NOT NULL,Place Varchar2(50) NOT NULL,durationNbHour Number NOT NULL); CREATE TABLE Organize (actid Number(3) Primary Key, clubID Number(3), Fee Number(4,2), Foreign Key(actid) references Activities(Actid),Foreign Key(clubID) references MemberOf(ClubID)); Write in SQL queries to populate the above tables by inserting minimum 4…
Your company needs to contact the 1st author of each textbook and to discuss reprint options. Pull out the 1st author for all the books. Please note that the order of authors has been marked as integer values 1, 2, 3, etc. in the field Auth_Order in the AuthorshipLog table. The query result should show the following information in the given order: Book title, 1st author’s last name, 1st author’s email, and 1st author’s phone. Save and name the query 2 First Author Contacts. How would I go about this in Access's query design?
USing sakila SELECT last_name, first_name, ROUND(AVG(length), 0) AS averageFROM actorINNER JOIN film_actor ON film_actor.actor_id = actor.actor_idINNER JOIN film ON film_actor.film_id = film.film_idWHERE title = "ALONE TRIP"GROUP BY last_name, first_nameORDER BY average;Highlight the SELECT query.In the main menu, select Query > Explain Current Statement.In the Display Info box, highlighted in red below, select Data Read per Join. The execution plan depicts the result of EXPLAIN for the SELECT query. The execution plan has seven steps, corresponding to the red numbers on the screenshot: Access a single film row using the idx_title index on the title column. Access matching film_actor rows using the idx_fk_film_id index on the film_id foreign key. Join the results using the nested loop algorithm. Access actor rows via the index on the primary key. Join actor rows with the prior join result using the nested loop algorithm. Store the result in a temporary table and compute the…