Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You manage data for Screwy, a screw manufacturer in southern Oklahoma City. The Screwy staff aren't too analytical and only maintain simple records of Orders
You manage data for Screwy, a screw manufacturer in southern Oklahoma City. The Screwy staff aren't too analytical and only maintain simple records of Orders in a single table. They also maintain two separate tables to keep track of their customers and part offerings. All of this is saved in a single database creatively named "Screwy".
Open this MySQL code and run it This will create the database Screwy for you to work with.
Or
Copy and paste the following SAS code Step Step to your SAS on demand instance to import the database. You should only need to use Step the first time you download the data. Step will need to be run each time your reset your SAS session.
The Orders table includes:
OrderNumber NumericPK
CustomerID NumericFK
PartNumber NumericFK
Quantity Numeric
TotalCost NumericTotalCost is in USD
The Parts table includes:
PartNumber NumericPK
PartName Text
The Customers table includes:
CustomerID NumericPK
CustomerName Text
CustomerCreditLine NumericCredit line is in USD
PK Primary Key, FK Foreign Key
Part SQL Coding
point graded
You have been asked to run some SQL scripts to help the Screwy team out. You want to find out the following things:
What was the total cost of OrderNumber
Enter the correct answer below.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started