Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Determine the amount of total profit generated by the book purchased on order
1002.
Display the book title and profit. The profit should be formatted to display a dollar
sign and two decimal places. Take into account that the customer might not pay the
full retail price, and each item ordered can involve multiple copies.
SELECT title, TO_CHAR(quantity-(paideach-cost), '$999.99')
FROM books JOIN orderitems USING (isbn)
WHERE order# = 1002;
SELECT title, TO_CHAR(quantity*(paideach-cost), '$999.99')
FROM books JOIN orderitems USING (isbn)
SELECT title, TO_CHAR(quantity*(paideach-cost), '$999.99')
FROM books JOIN orderitems USING (isbn)
WHERE order# = 1002;
SELECT title, TO_CHAR(quantity*(paideach-cost), '$999.99')
FROM books JOIN orderitems USING (isbn)
WHERE order# IN ( 1002,1003,1004)
Solve the following using multiple selections structure. Draw a flowchart only.
A variable to store the average score of the student’s prelim exam grade.
Knowledge Booster
Similar questions
- Jake’s Car Rental charges each customer a daily rental fee of $55. However, there is an additional charge for renting a luxury car. The additional charge is $10 if the customer has a Jake’s Luxury coupon; otherwise, the additional charge is $30. What are the primary and secondary decisions?arrow_forwardUse the code shown in Figure 4-54 to answer Review Questions 13 through 16. If strLevel = 1 OrElse strLevel = 2 Then lblStatus.Text = Bronze ElseIf strLevel = 3 OrElse strLevel = 4 Then lblStatus.Text = Silver ElseIf strLevel = 5 Then lblStatus.Text = Gold Else lblStatus.Text = Platinum End If Figure 4-54 Code for Review Questions 13 through 16 What will the code in Figure 4-54 assign to the lblStatus control when the strLevel variable contains the string 2? a. Bronze b. Gold c. Platinum d. Silverarrow_forwardUse the code shown in Figure 4-54 to answer Review Questions 13 through 16. If strLevel = “1” OrElse strLevel = “2” Then lblStatus.Text = “Bronze” ElseIf strLevel = “3” OrElse strLevel = “4” Then lblStatus.Text = “Silver” ElseIf strLevel = “5” Then lblStatus.Text = “Gold” Else lblStatus.Text = “Platinum” End If Figure 4-54 Code for Review Questions 13 through 16 What will the code in Figure 4-54 assign to the lblStatus control when the strLevel variable contains the string “5”? Bronze Gold Platinum Silverarrow_forward
- the calculation form should appear (figure 4) containing the following buttons :(logout (once clicked should take you to login form), Compute (should calculate the subtotal, Vat, discount ,total price and display details on a richbox), Reset(clear the form), Print(should print slip after transaction), New Stock(take you to next form to add new stock in table) and New User (should take you to the next form to add new user in the login_details table). The New user button once clicked, should show a windows form with a tab control on the first tab it should ask the user to input personal information and store the data in the same table as the login and signup table storing (ID as the primary key(number), Name(text), Lastname(text), Date of birth(date), Gender(text), Picture(image), Username(text) and Password(text). The second tab should ask the user for the following details (Address (text), Contact number(text), Qualification(text), Net Profit(currency)) and store data on a table named…arrow_forwardEvery EVALUATE statement must have an OTHER clause. Question 7 options: True Falsearrow_forwardThe following list shows the items and prices for a restaurant order. Calculate the total amount if there is 7.5% tax and the customer leaves a 15% gratuity. 1 appetizer: $8.99 2 entrees: $14.99 each 1 entree: $12.99 3 drinks: $1.99 each a. $70.96 b. $71.62 c. $75.31 d. $75.97 Please select the best answer from the choices provided A Mark this and retum No hand written and fast answer with explanationarrow_forward
- The code has an extra 11 on the 2nd row which doesn't match the questionarrow_forwardFor further information about the Assignment operator, please go here.arrow_forward7-Display last name of employees whose manager is KING.8-Display last name, salary and job title of all employees who earns more than the lowest salary. (Employees andJobs)9-Display all employees including King, who has no manager. Order the results by the employee number.10-Display the name and hire date of any employee hired after employee Davisarrow_forward
- The following statement uses a non-correlated subquery to find the South American country with the smallest population: SELECT * FROM Country WHERE Continent = 'South America' AND Population = (SELECT MIN(Population) FROM Country WHERE Continent = 'South America')\G Rewrite the statement to use a correlated subquery.arrow_forward¥ Question Completion Status: Given a truth table below with the first two columns of truth values provided: b. (p.q) 1 2 T F 4. Which of the answers below contains the truth values for the third column when f(p,q) = p q ? Column 3 Column 3 Column 3 truth values: Column 3 truth Column 3 truth values: truth values: truth values: values: 1 T 1 F 1 F 1 F 1 T None of the other answers O 2 F O 2 T 2 T 2 T provided is correct. 2 F 3 F 3 F 3 T 3 T 3 F 4 T 4 F 4 T 4 F 4 T Save All Answers Save and Su Click Save and Submit to save and subrmit. Click Save All Answers to save all answers. 0 日 la (99+ here to search 3.arrow_forwardHow about this 3) Prompt the user to search for the student id by the student's name.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L