> > >

Laravel Framework MCQs

Creating database view in migration laravel 5.2

CREATE VIEW wones AS SELECT (name from leagues) AS name join teams where (leagues.id = team.country_id) join players where (teams.id = players.team_id) join points where (players.id = points.player_id) sum(points.remnants) AS trem count(points.remnants where points.remnants < 4) AS crem

CREATE VIEW wones AS SELECT leagues.name, sum(points.remnants) AS trem sum(IF(points.remnants<4, 1, 0)) AS crem FROM leagues JOIN teams ON (leagues.id = team.country_id) JOIN players ON (teams.id = players.team_id) JOIN points ON (players.id = points.player_id);

DB::statement( 'CREATE VIEW wones AS SELECT leagues.name as name, sum(points.remnants) as trem, count(case when points.remnants < 4 then 1 end) as crem FROM leauges JOIN teams ON (teams.league_id = leagues.id) JOIN players ON (players.team_id = teams.id) JOIN points ON (points.player_id = players.id); ' );

All of the above

Answer

Correct Answer: CREATE VIEW wones AS SELECT leagues.name, sum(points.remnants) AS trem sum(IF(points.remnants<4, 1, 0)) AS crem FROM leagues JOIN teams ON (leagues.id = team.country_id) JOIN players ON (teams.id = players.team_id) JOIN points ON (players.id = points.player_id);

Explanation:

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

Laravel Framework Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it