Question
12.Write a query to get the month of the invoice date. e.g. invoice date 2014-04-16 should return April. HINT: Use MONTHNAME 13. Write a query
12.Write a query to get the month of the invoice date. e.g. invoice date 2014-04-16 should return April. HINT: Use MONTHNAME
13. Write a query to join vendor_name, vendor_city and vendor_state. The final output should be separated by comma and in Capital letters (CAPS). e.g. US POSTAL SERVICE, MADISON, WI HINT: USE UPPER and CONCAT
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
Database Systems For Advanced Applications 9th International Conference Dasfaa 2004 Jeju Island Korea March 2004 Proceedings Lncs 2973
Authors: YoonJoon Lee ,Jianzhong Li ,Kyu-Young Whang
2004th Edition
3540210474, 978-3540210474
