Skip to main content

Mock 3 Slot3 - Handson - 21st July RDBMS (20 Marks) 2.1 Customer details

Write a query to display customer id, customer name, and password of customers whose name starts with 'A'. The password contains the first 3 characters from the name and the first 3 digits from the phone number. Give alias name for password as PASSWORD. Sort the records based on id in descending order.

( Hint: Retrieve data from Customers tables )

Write a query to display customer id, customer name and password of customers whose name starts with 'A'. The password contains first 3 characters from name and first 3 digits from phone number. Give alias name for password as PASSWORD. Sort the records based on id in descending order. ( Hint : Retrieve data from Customers tables ) Evaluation Result: Result Description Summary of tests:(Note:Your query is evaluated against different datasets. Kindly do not Hardcode) +------------------------------+ | 2 tests run / 2 test passed Mock 3 Slot3 - Handson - 21st July RDBMS (20 Marks) 2.1 Customer details Accenture Mock test 2021 2022

Write a query to display customer id, customer name and password of customers whose name starts with 'A'. The password contains first 3 characters from name and first 3 digits from phone number. Give alias name for password as PASSWORD. Sort the records based on id in descending order. ( Hint : Retrieve data from Customers tables ) Evaluation Result: Result Description Summary of tests:(Note:Your query is evaluated against different datasets. Kindly do not Hardcode) +------------------------------+ | 2 tests run / 2 test passed Mock 3 Slot3 - Handson - 21st July RDBMS (20 Marks) 2.1 Customer details Accenture Mock test 2021 2022


Evaluation Result:


 
Result Description
 Summary of tests:(Note:Your query is evaluated against different datasets. Kindly do not Hardcode)

+------------------------------+
| 2 tests run / 2 test passed  |
+------------------------------+
Labels:

Comments

Post a Comment