User UserCard * USER_ID * UserlD * CardNum Name UserType Transaction * Trans_ID phone_Num City TransDate CardNum Amount Card Trans type * CardNum CardTypelD PIN UserType * UserTypelD ExpireDate...

1- List all the users and their card name using union
2- List all the users and their card name using Intersection

3- List all the card numbers with owner names and scheduled transactions, in case the user has
never used scheduled transaction show null or zero in the transaction column. (Hint use ISNULL
function)

Extracted text: User UserCard * USER_ID * UserlD * CardNum Name UserType Transaction * Trans_ID phone_Num City TransDate CardNum Amount Card Trans type * CardNum CardTypelD PIN UserType * UserTypelD ExpireDate balance Name TransactionType 8 Trans_Type ID TypeName CardType 8 CardTypelD Description Name Description


Extracted text: user TypelD name 1 Silver 2 Gold 3 Bronze 4 4 Common userld user Type phoneNum city name Ali 2 03036067000 Narowal 2 2 Ahmed 1 03036047000 Lahore 3 Аgeel 3 03036063000 Karachi 4 4 Usman 4 03036062000 Sialkot 5 5 Hafeez 2 03036061000 Lahore userlD cardNum 1 1324327436569 1 2343243253436 2 2324325423336 2343243253436 3 2324325436566 6 2324325423336 cardNum card TypelD PIN expire Date balance 1 1324327436569 3 1770 2022-07-01 43025.31 2 2324325423336 3 0234 2020-03-02 14425.62 3 2324325436566 1 1234 2019-02-06 34325.52 4 2324325666456 2 1200 2021-02-05 24325.3 2343243253436 2 0034 2020-09-02 34025.12 card TypelD name description 1 1 Debit Spend Now, Pay Now Credit Spend Now, Pay later 3 Gift Enjoy transld transDate cardNum amount trans Type 1 1 2017-02-02 1324327436569 500 1 2 2018-02-03 2343243253436 3000 3 3 3 2017-05-06 2324325436566 2500 2 4 4 2016-09-09 2324325436566 2000 1 5 2015-02-10 2324325423336 6000 4 trans TypelD typeName description 1 1 Withdraw NULL 2 Deposit NULL 3 Schedul. NULL 4 Failed NULL 234 N3