use simple and basic sql

Choose AdventureWorks from the sample databases to write the following queries: In the AdventureWorks database, how many employees are in each job category in the [HumanResources].[Employee] table. Sort the results by JobTitle. In the [HumanResources].[Employee] table, how many males and females are there? Return all columns from the [Person].[Person] table of people with a first name of 'Tom' In the [HumanResources].[Employee] table, how many employees are at [organizationLevel] 2 Return all [Person].[Address] table information for addresses in the city of "Bothell" Return all [Person].[Address] table information for [AddressLine1] where is "Rose Street" In the [HumanResources].[Employee] table how many males and females are in each job title that has 'buyer' in the job title List all employees from the [HumanResources].[Employee] who have [SickLeaveHours] less than 32 Return all information from [Person].[PersonPhone] for phone numbers in the 212 area code. Order the results by [PhoneNumberTypeId] then [PhoneNumber] From the [Purchasing].[Vendor] table, list all active preferred vendors with a credit rating of 3 . Return the columns: [AccountNumber], [Name], [PurchasingWebServiceURL]