O’zbekiston respublikasi axborot texnologiyalari va kommunikatsiyalarini rivojlantirish vazirlugi muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti

O’ZBEKISTON RESPUBLIKASI AXBOROT TEXNOLOGIYALARI VA KOMMUNIKATSIYALARINI RIVOJLANTIRISH VAZIRLUGI
MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENT AXBOROT TEXNOLOGIYALARI UNIVERSITETI






Kiberxavfsizlikfakulteti
Axborotxavfsizligiyo’nalishi 713-22 guruhtalabasi
Toirov JahongirMalumotlar Bazasifanidan
7­­–amaliyishi
Bajardi: Toirov Jahongir
Tekshirdi: Madraximov Alisher

create database Restaurants;

use Restaurants;
CREATE TABLE Restaurant1 (
rasta_Id INTEGER PRIMARY KEY,
taom_nomi TEXT NOT NULL,
kutish TEXT NOT NULL,
narxi TEXT NOT NULL,
afitsant_foiz TEXT NOT NULL

);
INSERT INTO Restaurant1 VALUES (0001, 'shashlik', '10 min', '30000', '10%');

INSERT INTO Restaurant1 VALUES (0002, 'baliq', '20 min', '70000', '10%');
INSERT INTO Restaurant1 VALUES (0003,'olot somsa', '5 min', '12000', '10%');
INSERT INTO Restaurant1 VALUES (0004,'assarti', '15 min', '170000', '12%');
INSERT INTO Restaurant1 VALUES (0005,'jaz', '9 min', '36000','12%');
INSERT INTO Restaurant1 VALUES (0006,'shashlik', '15 min', '18000', '12%');

SELECT * FROM Restaurant1 WHERE afitsant_foiz = '10%';

use Restaurants;
SELECT * FROM Restaurant1 WHERE afitsant_foiz = '12%';