The Queries in this page solved at the library database. It is a sample database generated by randomly records. You can download it from the link. You will see more than 500 examples in the future. You can filter from the search panel above by selecting sql statements. I hope you will like it

**Solution 1)**

```
Select gender,count(*) as StudentCount
from students
group by gender
```

ETİKETLER

1 - 9 - 30 - 32 -
**Solution 1)**

```
Select name,surname,takenDate from students,borrows
where students.studentId = borrows.studentId
```

**Solution 2)**

```
Select name,surname,takenDate from students
join borrows on students.studentId = borrows.studentId
```

ETİKETLER

1 - 7 - 8 - 35 -
**Solution 1)**

```
Select * from students
order by name
```

**Solution 2)**

```
Select * from students
order by 2
```

ETİKETLER

1 - 11 -
**Solution 1)**

```
Select * from students
where name like 'a%'
```

ETİKETLER

1 - 8 - 13 -
**Solution 1)**

```
Update students set name='Veli'
where name = 'Ali'
```

ETİKETLER

3 - 8 -
**Solution 1)**

```
Create Procedure sp_Devide(@n1 int,@n2 int,@division int output,@remaining int output) as
Begin
SEt @division = 0
While(@n2<=@n1)
Begin
Set @n1 = @n1-@n2
Set @division+=1
End
Set @remaining = @n1
End
--To Execute the Stored Procedure
Declare @d int,@r int
Execute sp_Devide 34,7,@d output,@r output
Select @d Division,@r Remaining
```

ETİKETLER

23 - 40 -
**Solution 1)**

```
Select * from students
where name like '_a%'
```

ETİKETLER

1 - 8 - 13 -
**Solution 1)**

```
Create Procedure AddTwoNumber(@p1 int,@p2 int,@Result int output)
as
Begin
Set @Result = @p1+ @p2
End
--To Execute The Procedure
Declare @r int
Execute AddTwoNumber 20,25,@r output
Select @r as Result
```

ETİKETLER

23 - 40 -
**Solution 1)**

```
Select sum(pageCount) from books
join authors on authors.authorId = books.authorId
where authors.name = 'John' and authors.surname = 'DosPassos'
```

ETİKETLER

1 - 7 - 8 - 30 - 35 -
**Solution 1)**

```
Select authors.name, authors.surname, books.name as bookName from authors
join books on authors.authorId = books.authorId
join types on types.typeId = books.typeId
where types.name = 'Drama'
```

**Solution 2)**

```
Select authors.name, authors.surname, books.name as bookName
from authors, books, types
where authors.authorId = books.authorId and
types.typeId = books.typeId and
types.name = 'Drama'
```

ETİKETLER

1 - 7 - 8 - 17 - 35 -
**Solution 1)**

```
Delete from students
where name = 'Gray' and surname = 'King'
```

ETİKETLER

4 - 8 - 17 -
**Solution 1)**

`Select min(pageCount) from books`

ETİKETLER

112 -
**Solution 1)**

```
Select * from students
order by newid()
```

ETİKETLER

1 - 11 -
**Solution 1)**

```
Create Procedure sp_isPrime (@number int,@result bit output) as
Begin
Set @result = 1
Declare @i int = 2
While (@i<@number)
Begin
if(@number % @i = 0)
Begin
Set @result = 0
break
End
Set @i += 1
End
retypesn @result
End
--To Execute The Stroed Procedure
Declare @result bit
Execute sp_isPrime 11,@result output
Select @result
```

ETİKETLER

23 - 40 -
**Solution 1)**

```
Select top 1 * from students
where sinif= '10A'
order by newid()
```

ETİKETLER

1 - 5 - 8 - 11 -
**Solution 1)**

`Select max(point) from books`

ETİKETLER

1 - 30 -
**Solution 1)**

`Select * from students`

ETİKETLER

1 -
**Solution 1)**

```
Select name,surname,count(borrowsno) BookCount
from students
left join borrows on students.studentId = borrows.studentId
group by students.studentId,name,surname
order by BookCount
```

**Solution 2)**

```
Select name, surname,
(Select count(*) from borrows
where students.studentId = borrows.studentId) as BookCount
from students
order by BookCount
```

ETİKETLER

1581018 -
**Solution 1)**

```
Select * from students
where name like '%a_'
```

ETİKETLER

1 - 8 - 13 -
**Solution 1)**

```
Select books.name as bookName, authors.name, authors.surname
from authors
join books on authors.authorId = books.authorId
where pagecount >300
```

**Solution 2)**

```
Select authors.name, authors.surname, books.name as bookName
from authors,books
where authors.authorId = books.authorId and pagecount >300
```

ETİKETLER

1 - 7 - 8 - 17 - 35 -
**Solution 1)**

```
Delete from students
where studentId not in
(Select studentId from borrows)
```

ETİKETLER

4 - 8 - 18 -
**Solution 1)**

```
Create Procedure sumThree
@n1 int,
@n2 int,
@n3 int,
@result int output as
Begin
Set @result = @n1+@n2+@n3
End
--To Execute The Procedure
Declare @result int
Execute sumThree 5,30,12,@result output
Select @result
```

ETİKETLER

23 - 40 -
**Solution 1)**

```
Create procedure factor(@number int)
as begin
Declare @i int = 1,@result int=1
while (@i<=@number)
Begin
Set @result = @result * @i
Set @i += 1
End
Select @result
End
```

ETİKETLER

23 - 40 -
**Solution 1)**

```
Select * from students
where studentId % 2 = 1
```

ETİKETLER

1 - 8 -
**Solution 1)**

```
Select * from students
where gender = 'M'
order by name
```

**Solution 2)**

```
Select * from students
where gender = 'M'
order by 2
```

ETİKETLER

1 - 8 - 11 -
**Solution 1)**

```
Select * from books
where bookId in(3,4,8,9,11,23)
```

**Solution 2)**

```
Select * from books
where bookId = 3 or
bookId = 4 or
bookId = 8 or
bookId = 9 or
bookId =11 or
bookId = 23
```

ETİKETLER

1 - 8 -
**Solution 1)**

```
Select sinif,count(*) as StudentCount
from students
group by sinif
having count(*) >= 30
```

ETİKETLER

1 - 9 - 10 - 32 -
**Solution 1)**

```
select * from students
where ("Edwards" or "Baker") and studentId<30
```

**Solution 2)**

```
select * from students
where name='Edwards' and studentId<30 or
name='Baker' and studentId<30
```

ETİKETLER

1 - 8 - 16 - 17 -
**Solution 1)**

```
select * from students
where name = 'Perez' and surname not like '%a%'
```

**Solution 2)**

```
select * from students
where name = 'Perez' and not surname like '%a%'
```

ETİKETLER

1 - 8 - 17 -
**Solution 1)**

```
Select sum(pageCount) from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
where students.name = 'Ainsley' and students.surname = 'Cooper'
```

ETİKETLER

1 - 7 - 8 - 17 - 30 - 35 -
**Solution 1)**

```
Create Procedure Sp_Random_Value
@first int,
@second int,
@result int output
As
Begin
Set @result =Floor(RAND() * (@second-@first))+@first
End
--To Execute the Procedure
Declare @r int
Execute Sp_Random_Value 20,30,@r output
Select @r
```

ETİKETLER

23 - 40 -
**Solution 1)**

```
Select sinif,gender,count(*) as StudentCount
from students
where gender = 'F'
group by gender,sinif
```

ETİKETLER

1 - 8 - 9 - 30 - 32 -
**Solution 1)**

```
Select * from books
where bookId like '%1%'
```

ETİKETLER

1 - 8 - 13 -
**Solution 1)**

```
Select students.name as studentName,
students.surname,books.name as BookName,
takenDate,types.name as TypeName,
authors.name as AuthorName, authors.surname as AuthorSurname
from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
join types on books.typeId = types.typeId
join authors on authors.authorId = books.authorId
```

**Solution 2)**

```
Select students.name as studentName,students.surname,
books.name as BookName,takenDate,types.name as TypeName ,
authors.name as AuthorName,authors.surname as AuthorSurname
from students, borrows, books, types, authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
books.typeId = types.typeId and
authors.authorId = books.authorId
```

ETİKETLER

1 - 7 - 8 - 35 -
**Solution 1)**

```
Select students.* from students
left join borrows on students.studentId = borrows.studentId
where borrowsno is null
```

**Solution 2)**

```
Select * from students
where studentId not in
(Select studentId from borrows)
```

ETİKETLER

1 - 8 - 18 - 35 - 37 -
**Solution 1)**

```
Create Procedure myPower(@num int,@pow int, @result int output) As
Begin
Declare @i int = 0;
Set @result = 1
while(@i<@pow)
Begin
Set @result = @result * @num
Set @i += 1
End
End
```

ETİKETLER

23 - 40 -
**Solution 1)**

```
select *from students
where (name='Kane' or name= 'Jane') and studentId <30
```

**Solution 2)**

```
Select * from students
where name='Kane' and studentId <30 or name='Jane' and studentId <30
```

**Solution 3)**

```
select * from students
where name in('Kane','Jane') and studentId<30
```

ETİKETLER

1 - 8 - 16 - 17 -
**Solution 1)**

```
Delete from books
where pageCount between 50 and 100
```

**Solution 2)**

```
Delete from books
where pagecount<=100 and pagecount>=50
```

ETİKETLER

4 - 8 -
**Solution 1)**

```
Select * from books
where bookId % 2 = 0
```

ETİKETLER

1 - 8 -
**Solution 1)**

```
Select top 1 * from students
where sinif= '10A' and gender= 'F'
order by newid()
```

ETİKETLER

1 - 5 - 8 - 11 - 17 -
**Solution 1)**

```
Select Year(takendate) as Year, datepart(qq,takendate) as Quarter,count(*) as Count
from borrows
group by Year(takendate),datepart(qq,takendate)
```

ETİKETLER

1 - 9 - 31 -
**Solution 1)**

```
Insert into students
values ('x','y',null,null,null,null)
```

**Solution 2)**

```
Insert into students(name,surname)
values ('x','y')
```

ETİKETLER

2 -
**Solution 1)**

```
Select count(*) from students
where sinif = '9B'
```

ETİKETLER

1 - 8 - 30 -
**Solution 1)**

```
Select students.name as OgrenciAd,
students.surname,books.name as KitapAd,
takenDate,types.name as TurAd
from students,borrows,books,types
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
books.typeId = types.typeId
```

**Solution 2)**

```
Select students.name as studentName,
students.surname,books.name as BookName,
takenDate,types.name as TypeName
from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
join types on books.typeId = types.typeId
```

ETİKETLER

1 - 7 - 8 - 35 -
**Solution 1)**

```
Select name,surname,count(*) BookCount
from students,borrows
where students.studentId = borrows.studentId
group by students.studentId,name,surname
```

**Solution 2)**

```
Select name,surname,count(*) BookCount
from students
join borrows on students.studentId = borrows.studentId
group by students.studentId,name,surname
```

ETİKETLER

1 - 7 - 8 - 9 - 30 - 32 - 35 -
**Solution 1)**

```
Select top 1 students.*,takendate
from students,borrows
where students.studentId = borrows.studentId
order by borrows.takenDate desc
```

**Solution 2)**

```
Select top 1 students.*,takendate
from students
join borrows on students.studentId = borrows.studentId
order by borrows.takenDate desc
```

**Solution 3)**

```
Select students.*,takendate
from students
join borrows on students.studentId = borrows.studentId
where takenDate = (Select max(takenDate) from borrows)
```

ETİKETLER

1 - 5 - 7 - 8 - 11 - 18 - 35 -
**Solution 1)**

```
Select name,surname,count(*) BookCount
from students
join borrows on students.studentId = borrows.studentId
group by students.studentId,name,surname
order by BookCount desc
```

**Solution 2)**

```
Select name,surname,count(*) BookCount
from students,borrows
where students.studentId = borrows.studentId
group by students.studentId,name,surname
order by BookCount desc
```

ETİKETLER

1 - 7 - 8 - 9 - 11 - 30 - 32 - 35 -
**Solution 1)**

`Select count(*) from students`

**Solution 2)**

`Select count(studentId) from students`

ETİKETLER

1 - 30 -
**Solution 1)**

```
Insert into authors(name,surname)
Select top 5 name,surname from students order by newid()
```

ETİKETLER

1 - 2 - 5 - 11 -
**Solution 1)**

```
Select * from student
where name like 'a%' and studentId % 2 = 1
```

ETİKETLER

1 - 8 - 17 -
**Solution 1)**

```
Select * from students
order by name desc
```

ETİKETLER

1 - 11 -
**Solution 1)**

```
Insert into authors
values('x','y')
```

**Solution 2)**

```
Insert into authors(name,surname)
values('x','y')
```

ETİKETLER

2 -
**Solution 1)**

```
Select sum(point) from books
join authors on authors.authorId = books.authorId
where authors.name = 'Emily' and authors.surname = 'Dickinson'
```

ETİKETLER

1 - 7 - 8 - 17 - 30 - 35 -
**Solution 1)**

```
Select students.name as studentName,students.surname,
books.name as BookName,takenDate
from students,borrows,books,types,authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and sinif='11B'
```

**Solution 2)**

```
Select students.name as studentName,students.surname,
books.name as BookName,takenDate
from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
where sinif='11B'
```

ETİKETLER

1 - 7 - 8 - 35 -
**Solution 1)**

`Delete from books`

ETİKETLER

4 -
**Solution 1)**

`Select avg(pageCount) from books`

ETİKETLER

1 - 30 -
**Solution 1)**

```
Insert into students(name,surname,sinif)
Select name,surname,'12M' from authors where name like '%a%'
```

ETİKETLER

1 - 2 - 8 -
**Solution 1)**

`Select count(*) from books`

**Solution 2)**

`Select count(bookId) from books`

ETİKETLER

1 - 30 -
**Solution 1)**

```
Select sum(pageCount) from books
join types on types.typeId = books.typeId
where types.name = 'Romance'
```

ETİKETLER

1 - 7 - 8 - 30 - 35 -
**Solution 1)**

```
Select * from students
where name like '%a%'
```

ETİKETLER

1 - 8 - 13 -
**Solution 1)**

```
Select avg(pageCount) from books
join types on types.typeId = books.typeId
where types.name = 'Comics'
```

ETİKETLER

1 - 7 - 8 - 30 - 35 -
**Solution 1)**

```
select * from students
where sinif='10A' and gender='M'
order by newid()
```

ETİKETLER

1 - 8 - 11 -
**Solution 1)**

`Delete from borrows`

ETİKETLER

4 -
**Solution 1)**

```
select * from students
where studentId=1 or studentId=7 or
studentId=11 or studentId=17
```

**Solution 2)**

```
select * from student
where studentId in (1,7,11,17)
```

ETİKETLER

1 - 8 -
**Solution 1)**

`Update books set point +=5`

**Solution 2)**

`Update books set point = point + 5`

ETİKETLER

3 -
**Solution 1)**

```
Insert into students(name,surname)
Select name,surname from authors
```

ETİKETLER

1 - 2 -
**Solution 1)**

```
Select count(*) from students
join borrows on students.studentId = borrows.studentId
where students.name = 'Alice' and students.surname = 'Wood'
```

ETİKETLER

1 - 7 - 8 - 17 - 30 - 35 -
**Solution 1)**

`Select sum(point) from students`

ETİKETLER

1 - 30 -
**Solution 1)**

```
Delete from students
where studentId in (Select studentId from borrows
group by studentId
having count(*)<5)
```

ETİKETLER

4 - 8 - 9 - 10 - 18 -
**Solution 1)**

```
Create procedure randomGenerate(@unit int,@min int,@max int)
as
Begin
Declare @numbers table(number int)
Declare @i int = 0
Declare @number int
while (@i<@unit)
Begin
Set @number = floor(rand()*(@max-@min+1))+@min
if(not exists(Select * from @numbers where number = @number))
begin
insert into @numbers values(@number)
Set @i = @i + 1
end
end
Select * from @numbers order by 1
End
--To Execute Stored Procedure
Execute randomGenerate 5,20,30
```

ETİKETLER

1 - 2 - 23 - 40 -
**Solution 1)**

```
Select count(*) from books
join authors on authors.authorId = books.authorId
where authors.name = 'Edna' and authors.surname = 'Ferber'
```

ETİKETLER

1 - 7 - 8 - 17 - 30 - 35 -
**Solution 1)**

```
Select students.name,students.surname,books.name,takenDate
from students,borrows,books
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId
```

**Solution 2)**

```
Select students.name,students.surname,books.name,takenDate from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
```

ETİKETLER

1 - 7 - 8 - 35 -
**Solution 1)**

```
Select count(*) from books
join types on types.typeId = books.typeId
where types.name = 'Horror'
```

ETİKETLER

1 - 7 - 8 - 30 - 35 -
**Solution 1)**

```
Select sinif,count(*) as StudentCount
from students
group by sinif
```

ETİKETLER

1 - 9 - 30 -
**Solution 1)**

```
Select count(distinct authorId) from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
where students.name = 'Ida' and students.surname = 'Gray'
```

ETİKETLER

1 - 6 - 7 - 8 - 17 - 30 - 35 -
**Solution 1)**

```
Select * from students
where name =
```*'Bill'*

ETİKETLER

1 - 8 -
**Solution 1)**

`Select name + surname from students`

**Solution 2)**

`Select name + surname as ns from students`

**Solution 3)**

`Select name + ' ' + surname as ns from students`

ETİKETLER

1 - 32 -
**Solution 1)**

`Update students set point=100`

ETİKETLER

3 -
**Solution 1)**

```
Select Year(birthdate) as Year, datepart(qq,birthdate) as Quarter,count(*) as Count
from students
group by Year(birthdate),datepart(qq,birthdate)
```

ETİKETLER

1 - 9 - 31 - 32 -
**Solution 1)**

```
Insert into authors(name,surname)
select name,surname from students
where sinif='9A' and gender='M'
```

**Solution 2)**

```
Insert into authors
select name,surname from students
where sinif='9A' and gender='M'
```

ETİKETLER

1 - 2 - 8 -
**Solution 1)**

```
Select students.name as studentName,students.surname,
books.name as BookName,takenDate
from students, borrows, books, types, authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
sinif='11B' and gender='F'
```

**Solution 2)**

```
Select students.name as studentName,students.surname,
books.name as BookName,takenDate
from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
where sinif='11B' and gender='F'
```

ETİKETLER

1 - 7 - 8 - 17 - 35 -
**Solution 1)**

```
Delete from students
where studentId = 5
```

ETİKETLER

4 - 8 -
**Solution 1)**

```
Select books.* from books
left join borrows on books.bookId = borrows.bookId
where borrowsno is null
```

**Solution 2)**

```
Select * from books
where bookId not in
(Select bookId from borrows)
```

ETİKETLER

1 - 8 - 18 - 35 - 37 -
**Solution 1)**

```
Select * from students
where gender = 'M'
order by newid()
```

ETİKETLER

1 - 8 - 11 -
**Solution 1)**

```
select * from students
where name= 'James' and surname not like '%a%'
```

ETİKETLER

1 - 8 - 13 - 17 -
**Solution 1)**

```
Select * from students
order by birthdate
```

ETİKETLER

1 - 11 -
**Solution 1)**

```
Select top 3 * from students
order by newid()
```

ETİKETLER

1 - 5 - 11 -
**Solution 1)**

`Select avg(point) from students`

ETİKETLER

1 - 30 -
**Solution 1)**

```
Select top 1 * from books
order by sayfaSayisi desc
```

**Solution 2)**

```
Select * from books
where sayafaSayisi=(Select max(sayfaSayisi) from books)
```

ETİKETLER

1 - 5 - 8 - 11 - 18 - 30 -
**Solution 1)**

`Select sum(pageCount) from books`

ETİKETLER

1 - 30 -
**Solution 1)**

`Select * from books`

ETİKETLER

1 -
**Solution 1)**

```
Select sinif,gender,count(*) as StudentCount
from students
group by gender,sinif
```

ETİKETLER

1 - 9 - 30 - 32 -
**Solution 1)**

```
Select distinct students.* from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
join authors on authors.authorId = books.authorId
where authors.name = 'Fyodor' and authors.surname = 'Dostoevsky' and sinif = '10A'
```

**Solution 2)**

```
Select distinct students.*
from students, borrows, books, authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
authors.authorId = books.authorId and
authors.name = 'Fyodor' and authors.surname = 'Dostoevsky' and
sinif = '10A'
```

ETİKETLER

1 - 7 - 8 - 17 - 18 - 35 -
**Solution 1)**

```
Select * from students
where studentId<= 20 and studentId< 30
```

**Solution 2)**

```
Select * from students
where studentId between 20 and 30
```

ETİKETLER

1 - 8 - 12 - 17 -
**Solution 1)**

```
Select distinct students.* from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
join authors on authors.authorId = books.authorId
where authors.name = 'Isaac' and authors.surname = 'Asimov'
```

**Solution 2)**

```
Select distinct students.*
from students, borrows, books, authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
authors.authorId = books.authorId and
authors.name = 'Isaac' and authors.surname = 'Asimov'
```

ETİKETLER

1 - 7 - 8 - 17 - 35 -
**Solution 1)**

```
Select * from students
where name like '%a'
```

ETİKETLER

1 - 8 - 13 -
**Solution 1)**

```
Insert into authors(name,surname)
values('Ernest','Dowson'),
('Mother','Goose')
```

**Solution 2)**

```
Insert into authors
values ('Ernest','Dowson'),
('Mother','Goose')
```

ETİKETLER

2 -
**Solution 1)**

```
Delete from students
where name = 'Gray'
```

ETİKETLER

4 - 8 -
**Solution 1)**

```
Select * from students
order by sinif,gender
```

ETİKETLER

1 - 11 -LIBRARY DATABASE