Introduction to SQL
What is the meaning of LIKE '%0%0%'

Feature has two 0's in it, at any position
Feature has more than two 0's
Feature begins with two 0's
Feature ends with two 0's

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the tuples having temperature greater than 'Paris'.

SELECT * FROM weather WHERE temperature > 'Paris' temperature
SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
NULL is

not a value
the same as blank for character
the same as 0 for integer
the same as 0 for integer and blank for character

ANSWER DOWNLOAD EXAMIANS APP