SCENARIO: We have table EMPLOYEE_INFO which contains Employee information. We want to display all characters before '@' in EMAILID field as Name field. Please see below in details.
TABLE NAME: EMPLOYEE_INFO
 |
| Employee_info Table |
EXPECTED RESULT:
SCENARIO: We have table COUNTRY_INFO which contains country names. Country_name field has some junk characters. Those junk characters are listed in Value_1 column. Those junk characters in Country_name need to be replaced with value_2 values for all occurrences while displaying. Please see below the scenario in details.
TABLE NAME: COUNTRY_INFO
 |
COUNTRY_INFO Table
|
EXPECTED RESULT:
SCENARIO: We have table EMPLOYEE_INFO which contains Employee information. We want the output table should display NAME field and it should contain EMPNAME field values leaving behind first and last character in it. Please see below in details.
TABLE NAME: EMPLOYEE_INFO
 |
| EMPLOYEE_INFO Table |
EXPECTED RESULT:
SQL- Scenario Based Questions PART- 4
SCENARIO:
Suppose there is a table which contains a column NetBalance which has both negative and positive values. Now you have to write a query to dispaly sum of all positive Balances and sum of all negative Balances.
Consider below BalanceInfo table for answering this scenario based questions:-
BalanceInfo Table
