Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

Question

Write Query

in progress 0
TheDataMonk 1 year 19 Answers 661 views Grand Master 1

Answers ( 19 )

  1. select student_name from students where (sex = ‘M’) OR (student_address like ‘%mumbai%’)

  2. Select * from students where gender = ‘Male’ or address like ‘%Mumbai%’

  3. Sorry it a private answer.

  4. Select name
    From students
    Where lower(gender) in (‘male’,’m’)
    Or lower(address) = ‘%mumbai%’

  5. SELECT STUDENT_NAME FROM STUDENT WHERE LOWER(GENDER) IN (‘MALE’ , ‘M’) OR LOWER(ADDRESS) = %MUMBAI%

  6. SELECT student_name
    FROM student WHERE LOWER(Gender) IN (“MALE”, “M”)
    OR LOWER(ADDRESS) = “%MUMBAI%”

  7. Select student_name from Students
    where lower(gender) in (‘male’, ‘m’) or lower(address) like ‘%mumbai%’;

  8. SELECT name FROM students
    WHERE lower(gender) in (‘male’, ’m’)
    OR lower(address) LIKE ‘%mumbai%’

  9. SELECT NAME FROM STUDENT WHERE LOWER(GENDER) IN (‘male’ , ‘m’) OR LOWER(ADDRESS) like %mumbai%

  10. select student_name from student where lower(student_gender) in (‘male’,’m’) or lower(student_address) like ‘%mumbai%’;

  11. SELECT student_name
    FROM students
    WHERE gender = ‘M’ OR address ILIKE ‘%mumbai%’

  12. SELECT* FROM students
    WHERE Gender = ‘Male’ or UPPER(address) like ‘%MUMBAI%’

  13. SELECT * FROM students
    WHERE gender = ‘Male’ or lower(address) LIKE ‘%mumbai%’

  14. SELECT student_name
    FROM student_data
    WHERE TRIM(LOWER(gender))=’male’
    OR TRIM(LOWER(address))=’%mumbai%’

  15. select stu_name from stu
    where gender=’m’ or
    address ilike ‘%Mumbai%’

Leave an answer

Browse
Browse