Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 340 Weeks Ago, 3 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Computer Science Posted 20 Apr 2017 My Price 20.00

Create and query databases using SQL

Create and query databases using SQL Value: 20% Submission method options Alternative submission method Task Part A: SQL Queries (50 marks) Use the ClassicModels  database (ClassicModels.sql) from the ITC114 Interact Resources site. Answer the following queries from that database.   You are required to submit: The appropriate SQL statements for each query, which should be copied from your SQL code in MySQL and pasted into your submission file; and Screenshots of the resultant tables which are to be pasted into your submission file immediately after the SQL code for that query. Typing or manually drawing the results is NOT acceptable.  NOTE: Your SQL code should be correct for any data, not just any sample data that you create.   Write SQL SELECT statements to retrieve the following information from the ClassicModels database: Select the product name, scale, vendor and product code for all models of classic cars built between 1948 and 1966. Display the results in order of manufacture. (5 marks Select the product name, scale, vendor and product code for all models of Vintage cars built before 1930 and with a scale smaller than 1:20. Display the results in order of manufacture. (5 marks) List the South East Asian (excluding Australian and New Zealand) customers of Classic Models. Show their Customer name, city, country, sales Rep name, email address and the sales office that supports them. Order the list by country and city. (5 marks) Which customers cancelled orders, how many different products were in the order and what was the reason for cancellation? (8 marks) Which employees work in a European office? List their office, their full name, their job title, the name and job title of the person that they report to. (7 marks) Which orders over $30,000 in value have been disputed and then later resolved? Who were the customers involved; how many different products were in their order; what was the total value of the disputed order? What was the...

Answers

(8)
Status NEW Posted 20 Apr 2017 04:04 PM My Price 20.00

-----------

Attachments

file 1492706686-create_and_query_databases_using_sql.docx preview (154 words )
C-----------rea-----------te -----------and----------- qu-----------ery----------- da-----------tab-----------ase-----------s u-----------sin-----------g S-----------QL ----------- Pr-----------ofe-----------sso-----------r -----------Nam-----------e -----------Dat-----------e ----------- A-----------ssi-----------gnm-----------ent----------- on----------- SQ-----------L -----------PAR-----------T A----------- (S-----------QL -----------QUE-----------RIE-----------S) ----------- 1.----------- S-----------ELE-----------CTÂ----------- pr-----------odu-----------ctN-----------ame-----------, -----------pro-----------duc-----------tSc-----------ale-----------, -----------pro-----------duc-----------tVe-----------ndo-----------r,Â----------- pr-----------odu-----------ctC-----------ode-----------FRO-----------M -----------`pr-----------odu-----------cts-----------` -----------WHE-----------REÂ----------- pr-----------odu-----------ctL-----------ine----------- =----------- &-----------quo-----------t;C-----------las-----------sic----------- Ca-----------rs&-----------quo-----------t;A-----------NDÂ----------- pr-----------odu-----------ctN-----------ame----------- &-----------amp-----------;gt-----------;=Â----------- &q-----------uot-----------;19-----------48%-----------&qu-----------ot;-----------AND----------- p-----------rod-----------uct-----------Nam-----------e -----------&am-----------p;l-----------t;=----------- &-----------quo-----------t;1-----------966-----------%&q-----------uot-----------;OR-----------DER----------- B-----------Y -----------pro-----------duc-----------tNa-----------me ----------- 2.----------- S-----------ELE-----------CTÂ----------- pr-----------odu-----------ctN-----------ame-----------, -----------pro-----------duc-----------tSc-----------ale-----------, -----------pro-----------duc-----------tVe-----------ndo-----------r,Â----------- pr-----------odu-----------ctC-----------ode-----------FRO-----------M -----------`pr-----------odu-----------cts-----------` -----------WHE-----------REÂ----------- pr-----------odu-----------ctL-----------ine----------- =----------- &-----------quo-----------t;V-----------int-----------age-----------
Not Rated(0)