Complete and execute simple sql queries??
Budget: $10 – $30 AUD
Hi, I have sql problems where the tables arent provided. I need semi solutions or solution descriptions.
B. Display cardtype and maximum creditlimit as “MAXLIMIT” (column alias) of the cardtype(s) that is appearing exactly 4 times. For the given sample data, following is the expected output.
Note: For the given requirement, display UNIQUE records wherever applicable.
C. Display cardno and transactionid for each ‘Gold’ card as “TRANSACTION” (column alias). Display TRANSACTION as ‘NA’ for those creditcards that are NOT used for any transaction. For the given sample data, following is the expected output.
Note: For the given requirement, display UNIQUE records wherever applicable.
D. Display the cardno and creditlimit of those creditcards that are of different cardtype and are owned by the same customer. For the given sample data, following is the expected output.
Note: For the given requirement, display UNIQUE records wherever applicable.
B. Display cardtype and maximum creditlimit as “MAXLIMIT” (column alias) of the cardtype(s) that is appearing exactly 4 times. For the given sample data, following is the expected output.
Note: For the given requirement, display UNIQUE records wherever applicable.
C. Display cardno and transactionid for each ‘Gold’ card as “TRANSACTION” (column alias). Display TRANSACTION as ‘NA’ for those creditcards that are NOT used for any transaction. For the given sample data, following is the expected output.
Note: For the given requirement, display UNIQUE records wherever applicable.
D. Display the cardno and creditlimit of those creditcards that are of different cardtype and are owned by the same customer. For the given sample data, following is the expected output.
Note: For the given requirement, display UNIQUE records wherever applicable.