#include <iostream>
#include <cmath>
using namespace std;

int main()
{
int a,j=0,c;
cin>>a;
c=a-1;
while(c>1){
if(a%c==0){
break;
}
else{
j++;
c--;
}
}
if(j==a-2){
cout<<a<<" Tub son ekan";
}
else{
cout<<"Tub son emas";
}
} Tub son yoki yo'qligini aniqlash

#CHALLANGE
create table Hackers(
hacker_id int,
name nvarchar(99)
)
insert into Hackers values
(5077,'Rose'),
(21283,'Angela'),
(62743,'Frank'),
(88255,'Patrick'),
(96196,'Lisa')

create table Challenges(
challenge_id int,
hacker_id int
)
insert into Challenges values
(61654,5077),
(58302,21283),
(40587,88255),
(29477,5077),
(1220,21283),
(69514, 21283),
(46561,62743),
(58077,62743),
(18483,88255),
(76766,21283),
(52382,5077),
(74467,21283),
(33625,96196),
(26053,88255),
(42665,62743),
(12859,62743),
(70094,21283),
(34599,88255),
(54680,88255),
(61881,5077)

select * from Hackers
select * from Challenges

with AABB as(
select c.hacker_id,h.name,c.nums, ROW_NUMBER() over (partition by c.nums order by c.nums) as son
from (select hacker_id, count(challenge_id) as nums from Challenges group by hacker_id) c
inner join Hackers h
on h.hacker_id=c.hacker_id
)
select hacker_id,name,nums from AABB
where name in (select case
when nums in (select nums from AABB where son>1) and nums=(select max(nums) from AABB) then name
when nums in (select nums from AABB where son>1) and nums!=(select max(nums) from AABB) then null
else name
end
from AABB)

XATO

/*TUB SONLAR N GACHA BO'LGAN*/
#include <iostream>

using namespace std;

int main()
{
int a=2,c,f=0,b;
cin>>b;
while(b>=a){
c=a-1;
while(c>1){
if(a%c==0){
f++;
break;
}
else{
c--;}
}
if(f==0){
cout<<a<<" ";
}
else{
f=0;
}
a++;

}
}

Functions inline table Valued

1. Creating a trigger to update a column when a row is inserted:

CREATE TRIGGER trg_UpdateColumn
ON TableName
AFTER INSERT
AS
BEGIN
    UPDATE TableName
    SET ColumnName = 'New Value'
    WHERE Id IN (SELECT Id FROM inserted)
END;

2. Creating a trigger to insert data into another table when a row is updated:

CREATE TRIGGER trg_InsertData
ON TableName
AFTER UPDATE
AS
BEGIN
    INSERT INTO OtherTable (Column1, Column2)
    SELECT Column1, Column2 FROM inserted;
END;

3. Creating a trigger to delete rows from another table when a row is deleted:

CREATE TRIGGER trg_DeleteData
ON TableName 
AFTER DELETE 
AS 
BEGIN 
    DELETE FROM OtherTable WHERE Id IN (SELECT Id FROM deleted); 
END;

sql server - Full execution history of a stored procedure - Stack Overflow
https://stackoverflow.com/questions/57886434/full-execution-history-of-a-stored-procedure