User Account

All Pages

Write sql queries to produce list occurrences of adv pastels

Assignment Help PL-SQL Programming
Reference no: EM131505262

Assignment

The following questions refer to the Art Course database. You can obtain a copy of this data in the Access 2010 database, located on Canvas the course Web site listed below under this assignment or you could simply download it by clicking the file name here Art_Course_Database.accdb).

CUSTOMER (CustomerNumber, CustomerName, Phone)
COURSE (CourseNumber, Course, CourseDate, Fee)
ENROLLMENT (CustomerNumber, CourseNumber, AmountPaid)

where

CustomerNumber in ENROLLMENT must exist in CustomerNumber in CUSTOMER
CourseNumber in ENROLLMENT must exist in CourseNumber in COURSE

Write SQL queries to produce the following results:

1) List all occurrences of Adv. Pastels. Include all associated fields for each occurrence of the class.

2) List the minimum, maximum, and average full fee amount paid in the ENROLLMENT table.

3) List the total amount paid by each enrolled customer.

4) List the customer full name in one column whose last name ends with letters ‘son'. Sort the results by customer last name in descending order.

5) List the CustomerNumber and the amount due for those customers who haven't paid in full for their courses yet.

Reference no: EM131505262

Questions Cloud

Prepare an essay describing the use of an olap data cube : Write a 2 to 3 page essay describing the use of an OLAP Data Cube. Your essay should also describe the operations of Drill Down, Roll Up, Slice, and Dice.
What is the compensation system : Describe the results of your assessment of the work processes and key employees to be addressed in your final paper.
Project on a topical issue on business ethics : To allow students to demonstrate their ability to research, critically analyze trends and issues in their chosen topic, and communication their peers.
Essay on ethical behaviour of social media by young adults : Essay on ethical behaviour of social media by young adults. Give background to the chosen issue or topic; set parameters or scope of topic
Write sql queries to produce list occurrences of adv pastels : Write SQL queries to produce the List all occurrences of Adv. Pastels. Include all associated fields for each occurrence of the class.
Different understandings of social change : The authors highlight three different understandings of social change. These views of social change correspond to three very different perspectives.
Ethical effects of information technology by social media : Essay is on social and ethical effects of Information technology by social media. 2200-2500 words
Conduct a security survey of the selected building : Conduct a security survey of the selected building in which you assess the following: The need for security personnel.
Identify the primary groups : Identify the primary groups that you belong to. Be sure to explain which primary groups have had the most influence in shaping your values.

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd