SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 3 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 11 Oct 2017 My Price 10.00

please guys i need help with understanding what put in SQL .

please guys i need help with understanding what put in SQL ..it shows that i have errors when type in my query

Project 1 BUSA 326 You need the SalesOrdersExample database to complete this project. If you have not installed the database in MySQL, please refer to the “SQL installation guide”, and “Load SQL Script” shown in Week 5 to set up the database. 1. Use the customers table inside of the salesordersexample database, and write a query statement to show all data records of the customers table. (10 points) 2. Use the customers table inside of the salesordersexample database, and write a query statement to show data records from the CustFirstName, CustLastName, and CustCity columns. (10 points) 3. Use the employees table inside of the salesordersexample database, and write a query statement to show the employee’s EmployeeID, EmpFirstName, EmpLastName, and EmpPhoneNumber, if the employee is living in the 98413 zip code. (10 points) 4. Use the employees table inside of the salesordersexample database, and write a query statement to show each employee’s EmployeeID, EmpFirstName, and EmpLastName. Also, in the report, create a new column called EmpAge, in which you use a date expression to calculate and show the employee’s age today. (Hint: A similar analysis can be found in the developer guide related to expressions on eCollege). (20 points) 5. Use the orders table inside of the salesordersexample database, and write a query statement to show the ShipDate, EmployeeID, and CustomerID for those orders that have a CustomerID greater than 1013, and EmployeeID is 708. (15 points) 6. Use the order_details table inside of the salesordersexample database, and write a query statement to show all the information related to ProductNumber 16. (20 points) 7. Use the vendors table inside of the salesordersexample database, and write a query statement to show the name of the Vendor(s) from WA. (15 points) What to Submit 1. Copy/Paste the above questions in a document. 2. Write your SQL query statements below each question (i.e. Copy/paste from MySQL). 3. Get a screenshot of the Result Grid after you execute each query in MySQL, and copy/paste into the document as well (below the SQL query). 4. List the Number of Rows Returned – shown in the Action Output pane at bottom of MySQL window (e.g. 3 row(s) returned). 5. Name the document as “Project1_YourLastName”. 6. Convert the document to .PDF, and submit it to Dropbox on eCollege by the listed date.

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 11 Oct 2017 05:10 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)