16. Retrieve the amount of accounts we have per category Show the customer full name and address, their cell phone number. Sh

Using SQL

16. Retrieve the amount of accounts we have per category Show the customer full name and address, their cell phone number. Show the employee full name and their identification number. Sort it by employee identification number in descending order. Format the customer and employee full 17. name Retrieve customer full name their email, account number and 18. balance. Format the cUstomer name and balance Retrieve customer full name their email, their loan number 19. and amount. I only want to see those customers whose loan amount is over 5000 and live in NY or CO Show the loan number of the loan, payment date, payment 20. amount and payment date. I want to see how much there loan amount is after payment. 21. Show all the users whose Last name ends with y 22. Show the customer identification number their first and last name and email. I only want those users whose Last name contains an ff or on



Source link

Leave a Reply

Your email address will not be published.