In the context of an SQL statement, we need to understand when a tick mark be used and when should a single quote be used. Choose all the statements below that use single tick marks and single quotes correctly. code example
Example: sql quote in string
/*adding single quote into the string in SQL*/
on P.SupplierID=S.SupplierID
where S.CompanyName in
('Tokyo Traders','Exotic Liquids','Grandma Kelly''s Homestead')