Considering the SQL table `jobs` which is about job offers which column names are (`shift`,`count`,`post date`,`job description`,`skills`,`employment type job status`,`job id`,`advertiser url`,`company`,`id`,`job location address`,`job title`,`site name`)
Write a SQL query that returns numbers of job offers in NY. Return only the SQL code