Assignment
4A: Lab – Script (Schedule Date, Order Number, etc.)
Create
a script that returns complete date, Schedule date, and Order Number from
the Order table.
Create
a column that adds five days to the complete date. Call the column
‘Call Date’
Alias
the Order table
Create
a column that shows the amount of time between the schedule date and
complete date
Order
By Schedule Date
Show
your script and Results
Create
a script that returns Current Offer and charge from the Service table
Count
the number of each offer
Show
your script and results
Create
a script that pulls Course number and course name from the Course table
Only
pull courses that have the word ‘the’ in their description
Before
running the script – how many records do you think will be returned
Change
the Course number column to say ‘Course #’
Change
the Name field to say ‘Course Description’
Show
your pre-guess, script, and the results
To submit assignment, put the information above in a Word
document, including a copy of the actual SQL script required for each of the
three items. Load Word document with all content into the assignment box
for instructor review and grading.
Assignment
5A: Lab – Script (Customer, Order)
1) Create a script that pulls all the
columns for the Customer and Order tables
a) With the Customer as the primary table,
do a right join with the Order table
b) Before running the script – how many
records do you think will be returned?
c) Show your pre-guess, script, and the
results
2) Create a script that pulls Customer
first name, last name, current offer, and charge amount
a) For all the customers with a CAMP_CODE
of ‘BH’ add $.50 to their charge amount
b) For all the customers with a CAMP_CODE
of ‘CD’ add $.75 to their charge amount
c) For all the customers with a CAMP_CODE
of ‘PV’ add $1.00 to their charge amount
d) For all the customers with a CAMP_CODE
of ‘VB’ add $.25 to their charge amount
e) Create a new field called ‘Rate
Increase’ to show the new amounts.
f) Show your script and results
3) Create a script that pulls Student
First Name, Last Name, course term and name they are associated with, and any
grades they might have.
a) Concatenate the first and last name to
appear last name first and first name last with a coma between.
b) For any grades above 3.0 add .25.
For any grade below 3.0 subtract .25
c) Show your script and results
Note: I have uploaded all the document needed to run the scripts. Please also use SQLite application.
For This or a Similar Paper Click Here To Order Now
