(Solved): kindly solve all parts for sql For this exercise use the following schema, the script to create ...

kindly solve all parts for sql

For this exercise use the following schema, the script to create this schema and populate data is given. Tasks 1- List the card numbers of those cards that are not used for transaction 2- List the user who have amount less than 30000 in their cards. 3- List the user names having debit card type only. 4- List all the users made failed transactions. 5- Which users have gold cards as well as balance greater than 30000 . 6- Which user had a failed transaction and list the amount he tried to transact. 7- Give the user who has second maximum balance. 8- List the User names whose have not made any withdrawal transactions and belong to Lahore. 9- Which city has the user's having maximum balance.