Select *
From student_tbl (table name)
Where faculty LIKE 'Sc%' ;
within the faculty column that start with Sc followed by any number of characters
--
Select *
From student_tbl (table name)
Where Country In ('USA' , 'UK' ) ;
Select *
From student_tbl (table name)
Where faculty LIKE 'Sc%' ;
--
Select *
From student_tbl (table name)
Where Country In ('USA' , 'UK' ) ;