How would you Write a query in oracle to select all the teams that won either 2 or 4 or 6 or 8 games?

Answer 1

create a table with the name 'team'

CREATE TABLE team(team_no NUMBER(4),team_name VARCHAR2(20),team_loose NUMBER(3),team_own NUMBER(3));

insert values into a table team:

INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'royal',3,2);

INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'daredevils',2,6);

INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'chennai',4,2);

INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'rajsthan',2,4);

INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'kerala',5,8);

SELECT team_name from team WHERE team_own IN(2,4,6,8);