Question
Using Application Express, complete the following Hands-On Assignments: 1 List all book titles in mixed case (upper case first letters, the rest in lower case)
Using Application Express, complete the following Hands-On Assignments:
1 List all book titles in mixed case (upper case first letters, the rest in lower case) along with the publishers contact name and the age of the book in months (show full months that have passed between two dates only). Q2 Create a query to show the ISBN, the title in mixed case, the authors name, current retail price, and the new price with 15% discount. Round the result to cents (two decimals). Q3 Display total profit for order 1014, in results, include title in mixed case and profit formatted with $ and no decimal places. Consider that the book may be purchased in multiple quantities. Q4 Display the current date, day of the week, hours, minutes and seconds. Q5 Display a list of each book title and ISBN, as well as 8th and 9th digits of ISBN and a position of the third occurrence of a 0 in the ISBN. Create a single query. Q6 Find the length of the publisher's name field and show each value only once in results. Q7 Find the date for next Thursday based on today's date. Q8 Create a list of all customers and their street addresses, precede each street address with plus sign so the width of the displayed address field is 25.
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