What is the query?
- Database What Is The Query 1 (50.54 KiB) Viewed 19 times
DATABASE What is the query?
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
DATABASE What is the query?
DATABASE
What is the query?
Question 2 (2 points) ◄ Listen Submit just the SQL to: Return Company Name as Company (suppliers table) truncated to 20 characters, if the name is less than 20 characters embed a period for each space. Return Product Name (products table) as Product truncated to 15 characters, if the product name is less than 15 characters embed a space. Return product price expanded to 7 characters as Padded Price, if the product price is less than 7 characters embed leading asterisks for each missing character. Sort on price highest to lowest
What is the query?
Question 2 (2 points) ◄ Listen Submit just the SQL to: Return Company Name as Company (suppliers table) truncated to 20 characters, if the name is less than 20 characters embed a period for each space. Return Product Name (products table) as Product truncated to 15 characters, if the product name is less than 15 characters embed a space. Return product price expanded to 7 characters as Padded Price, if the product price is less than 7 characters embed leading asterisks for each missing character. Sort on price highest to lowest