Terminology: For each description below, give the appropriate term to match the

Question

Terminology: For each description below, give the appropriate term to match the description. There is a table that lists the different stores a retail location operations and different attributes about each store is contained in a column of the table. One of these attributes is location and another lists the date the store was first opened. Employees are listed in a payroll database. There is a field that contains numbers that the employees are given upon hire, and no two employees have the same number. Someone writes code that will search the database to tell their boss how many deliveries they have made to Hawaii in the past month Hawaii in the past month. In a hospital database, there is a patient table, and every line in the table contains information from a patient. A firm has a policy that only gives permission to alter or change data already stored in the database. A field in a table listing delivery addresses has numbers that uniquely identify which customer is attached to the delivery. SQL Statement: For each description below, list in which SQL clause you would need to place the criteria. A store tracks the materials they use in their clothing in a database table. They want to know all materials having an average price of more than $20/sq.yard. A company has a log of customer transactions that includes the total price of the merchandise bought in that transaction. A manager wants a list of transactions sorted by these totals from highest to lowest. A retail merchandiser has a payroll table that tracks employee hours by store. The manager asks for a number of hours worked, but he w ants this information show n by store. An oil company has a list of drill sites the company owns in a database table. They w ant to look at a list of drill sites located in Oklahoma. An elementary school tracks their incoming students in a database. Shown below is the first five records of the student table (there are more records). The school wants to know the average age of the incoming students who are new to the school by the grade they are entering, sorted from lowest to highest grade (0 = Kindergarten). Write the SQL query to find that information. An elementary school tracks their incoming students in a database. Shown below is the first five records of the student table (there are more records). The school wants to know average age of the incoming students who are new to the school by the grade they are entering, sorted from lowest t highest grade (0 = Kindergarten). Write the SQL query to that information.

Explanation / Answer

2.a select * from materials_table_name where price>=(select avg(price) from materials_table_name where sal>avg(price) group by price)

2.b.select total from customer_transction_table_name order by desc

2.c.select count(hours) from payroll_table_name

2.d select coutn(drillsites), drillsites from oil_company_table where location=' Okalahome'

3.select avg(age) from students_table where grade=0

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.