Question

mysql

1. Produce a list of all customer names in which the first letter of the first and last names is in uppercase and the rest are in lowercase. Answer:

2. Create a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text “NOT REFERRED” if the customer wasn’t referred to the BookStore by another customer or “REFERRED” if the customer was referred. Answer:

3. Display a list of all book titles and the percentage of markup for each book. The percentage of markup should be displayed as a whole number (that is, multiplied by 100) with no decimal position, followed by a percent sign (for example, .2793 = 28%). (The percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.) Answer:

4. Create a list of all book titles and costs. Precede each book’s cost with asterisks so that the width of the displayed Cost field is 12. Answer:

Answer 1

1.

Select initcap(firstname), initcap(lastname) from customers

2.

Select customerNumber, NVL2(referred, 'REFERRED', 'NOT REFERRED') from customers;

3.

Select title, Round((retail - cost)/cost * 100, 0)||'%' from books;

4.

Select title, LPAD(cost,12,'*') from books;

Do ask if any doubt. Please upvote.