What syntax is correct for filtering seller name’s meta and male?

  • A. SELECT * FROM tblseller WHERE name = ‘meta’ & gender = ‘male’
  • B. SELECT * FROM tblseller WHERE name = ‘meta’ && gender = ‘male’
  • C. SELECT * FROM tblseller WHERE name = ‘meta’ AND gender = ‘male’
  • D. None correct

Answer: Option C