--Task 11

--Task 11
Find all items and information whether and what forbidden game types they have. Display item name, price, min level and forbidden game type. Display all items. Sort the results by game type in descending order, then by item name in ascending order.

select
	i.Name as Item,
	i.Price,
	i.MinLevel,
	gt.Name as [Forbidden Game Type]
from Items i
left join GameTypeForbiddenItems gtfi
on i.Id = gtfi.ItemId
left join GameTypes gt
on gtfi.GameTypeId = gt.Id
order by [Forbidden Game Type] desc, i.Name asc