Assuming that you are connected to a database table called Computers with the fields Computer, Hostname Room_Num, CPU_Type, Num_CPUs, Bit_Size,…

Assuming that you are connected to a database table called Computers with the fields Computer, Hostname Room_Num, CPU_Type, Num_CPUs, Bit_Size, Speed, OS_Type, Memory, and HDD_Size. write the SQL Query String sqlStr such that all the fields will be displayed for the records that indicate a speed greater than 2 and a memory value greater than 4. The returned records should be sorted by OS_Type.

Leave a Reply