Programming > QUESTIONS & ANSWERS > Questions and Answers > Computer Science Engineering & Technology. National Open and Distance Unive (All)

Questions and Answers > Computer Science Engineering & Technology. National Open and Distance University. Display customer full name with their title (Mr/Ms), both first name and last name are in upper case, customer email id, customer creation date and display customer's category after applying below categorization rules: i) IF customer creation date Year <2005 Then Category A ii) IF customer creation date Year >=2005 and <2011 Then Category B iii)IF customer creation date Year>= 2011 Then Category C Hint: Use CASE statement, no permanent change in table required.

Document Content and Description Below

Display customer full name with their title (Mr/Ms), both first name and last name are in upper case, customer email id, customer creation date and display customer's category after applying below c ... ategorization rules: i) IF customer creation date Year <2005 Then Category A ii) IF customer creation date Year >=2005 and <2011 Then Category B iii)IF customer creation date Year>= 2011 Then Category C Hint: Use CASE statement, no permanent change in table required. [NOTE: TABLES to be used - ONLINE_CUSTOMER TABLE] Computer Science Engineering & Technology display customer full name with their title (Mr/Ms), both first name and last name are in upper case, customer email id, customer creation date and display customer's category after applying below categorization rules: i) IF customer creation date Year <2005 Then Category A ii) IF customer creation date Year >=2005 and <2011 Then Category B iii)IF customer creation date Year>= 2011 Then Category C Hint: Use CASE statement, no permanent change in table required. [NOTE: TABLES to be used - ONLINE_CUSTOMER TABLE] Computer Science Engineering & Technology [Show More]

Last updated: 2 years ago

Preview 1 out of 2 pages

Buy Now

Instant download

We Accept: