Quyida keltirilgan masalalar uchun C++ va sql tillarida dastur kodlarini mos jadval kataklariga yozing


Download 11.08 Kb.
Sana18.12.2022
Hajmi11.08 Kb.
#1031176
Bog'liq
1-hafta topshiriqlari (2)


1-hafta mustaqil yechish uchun topshiriqlar.
Quyida keltirilgan masalalar uchun C++ va SQL tillarida dastur kodlarini mos jadval kataklariga yozing.
Guruh__di20-11______ FISH Narzullayev Doniyorbek
1.Elementlari 5,1,3,9,12,583,998,7538,72,53,71,85,7,2,9 sonlardan iborat massiv berilgan. Mazkur massivning elementlari orasidan eng kattasi topilsin (20%).

C++ (imperativ) tilidagi kod

SQL(deklarativ) tilidagi kod







2.Elementlari 5,1,3,9,12,583,998,7538,72,53,71,85,7,2,9 sonlardan iborat massiv berilgan. Mazkur massivning elementlari orasidan eng kichigi topilsin.(20%).

C++ (imperativ) tilidagi kod

SQL(deklarativ) tilidagi kod





3.Quyida quyoshning sayyoralarini tavsiflovchi Planets jadvali berilgan. Xalqasi bor(HavingRangs) sayyoralar ekranga chiqarilsin. (20%).



ID

PlanetName

Radius

SunSeason

OpeningYear

HavingRings

Opener

1

Mars

3396

687

1659

No

Christiaan Huygens

2

Saturn

60268

10759.22



Yes



3

Neptune

24764

60190

1846

Yes

John Couch Adams

4

Mercury

2439

115.88

1631

No

Nicolaus Copernicus

5

Venus

6051

243

1610

No

Galileo Galilei




C++ (imperativ) tilidagi kod

SQL(deklarativ) tilidagi kod





4. Quyida Universities jadvali berilgan. Fakultetlari soni 20 tadan ko’p bo’lgan universitetlar soni aniqlansin (20%).



ID

UniversityName

Students

Faculties

Professores

Location

1

Perm State National Research University

12400

12

1229

Perm

2

Saint Petersburg State University

21300

24

13126

Saint-Petersburg

3

Novosibirsk State University

7200

13

1527

Novosibirsk

4

Moscow State University

35100

39

14358

Moscow

5

Higher School of Economics

20335

12

1615

Moscow

6

Ural Federal University

57000

19

5640

Yekaterinburg

7

National Research Nuclear University

8600

10

936

Moscow

5. Elementlari 5,1,3,0,12,0,998,0,72,53,0,85,7,2,9 sonlardan iborat massiv berilgan. Massivda nechta 0 borligini aniqlansin (20%).

C++ (imperativ) tilidagi kod

SQL(deklarativ) tilidagi kod





Download 11.08 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling