Simple SQL questions

 

-- 1
Select name, Unit
From borrower's information table user;
-- 2
Select *
From book info table bookinf;
-- 3
Select *
From borrower's information table user
Where unit = 'computer Emy ';
-- 6
Select title, author, price
From book info table bookinf
Where press = 'tsinghua University Press ';
-- 8
Select *
From book info table bookinf
Where price between 30 and 50;

-- 11
Select title, author, publisher, price
From book info table bookinf
Where name like '% database % ';

-- 12
Select title, author, publisher, price * 1.5
From book info table bookinf
Where name like '% database % ';