Find the username and level of the players that own a pistol
	Select distinct username, level
from player, firearm
where type=’pistol’;

List the firearms and the value of them that are shotguns
	Select distinct item_url, value
from item, firearm
where type=’shotgun’;

How many traders are there?
	Select count(trader_name) as ‘Number of Traders’
from traders;

Find the average money of the users that have more than 500
	Select avg(money)
from player
where money>100;

Find the firearm and penetration where the damage is below 50
	Select item_url, penetration
from caliber
where damage<50;

Find the username of the players that bought more than 5 items in descending order
	Select username
from player_buys by username
having count(item_url)>5
order by username desc;

Find the item where the recoil_mod from the attachment is 25
	Select item.url
	From item, attachment
	Where attachment.recoil_mod=’25’;

Find the username and money a player has where their name starts with ‘An’
	Select username, money
	From player
	Where username like ‘an%’;


List the users and guns the players have that are above level 20 and have money above 1000 in ascending order
	Select username, item_url
	From player, owns
	Where level>20 AND money>1000
	Order by username asc;