Question

HOTS
CName
6. Consider the table BANK given below. Write command in Mysql for (i) to (iv) and output
for (v)
AccNo
BName Amount DateOfOpen Transactions
Karan
Bank Of 115000 2008-01-12 10
Baroda
Puneet State Bank 125000 2007-02-01 09
Anirban Oriental 117000 2009-07-15 05
Bank
Yatin
Standard 1 138000 2009-02-10 11
Chartered
Sunny State Bank 147000 2008-02-8 15
6
Jayant UCO Bank | 134000 2008-08-10 12
i. Display data for all customers whose transaction is between 8 and 11.
ii. Display data of all customer sorted by their date of open.
To show the details of customers with amount <13000
*​

Answer 1

an operating system is required for controlling the hardware and software of the computer mouse can be used to select the items on the screen distributed operating system also related to the content of the window address or display information related to the content of the window and it is usually friendly and easier to use themit is a master control of program of computer in which a popular operating system for mobile phone and interface it is mostly used in modern computer minimise button is located at the corner of the window