Select DISTINCT Name, city from tblperson
tanlangan kolubdagilarni takrorlanmaydigan qatorlarini chiqarish

select bilan ishlatiladigan operatorlar

int va nvarchar li columblarni qo'shib chiqarish uchun int lini nvarcharga o'tqazish kerak

#Select 1

SELECT CASE
WHEN A + B > C AND B + C > A AND A + C > B THEN
CASE
WHEN A = B AND B = C THEN 'Equilateral'
WHEN A = B OR B = C OR A = C THEN 'Isosceles'
ELSE 'Scalene'
END
ELSE 'Not A Triangle'
END
FROM TRIANGLES;

Create database HR12
Create table
EMPLOYE(
Employe_ID int primary key,
Employe_FName nvarchar (99),
Employe_LName nvarchar (99),
Employe_hiredate date ,
Employe_Title nvarchar (99) default 'UNKNOWN'

)
insert into EMPLOYE(Employe_ID,Employe_FName,Employe_LName)
values (1213,'Hoshimjon','Roziyev')

select * from EMPLOYE

create table SKILL(
Skill_ID int identity (100,10) primary key,
Skill_Name nvarchar (99),
Skill_Description nvarchar (155)
)

Create table CERTIFIED(
Employe_ID int references EMPLOYE(Employe_ID),
Skill_ID int check (Skill_ID>99 and Skill_ID<221) references SKILL(Skill_ID),
Certified_Date date not null

)