Simple SQL Query Here\'s a table named \"info\" that is in the database first na

Question

Simple SQL Query Here's a table named "info" that is in the database first name pick_integer tv show three_words msu id 42 Top Gear Walking Dead Mr. Robot walajahi Aasiruddin hello He arigato cunni285 er space book state wasakik Koshiro 21 a bee see eckmanca Caleb 57 Parks and Recreation nuclear frostbite catapult code python database pea slide cook tsaipoan Po-An 7 NULL levenegr Grant House Of Cards dennisr5 Renee 394 The Office banana nut muffin sunangel Angela 2 Grey's Anatomy meow, ew, dgross werner20 Write a query that returns just the first names and favorite tv shows of the students who picked integers less than 10 or greater than 50, and it must have at least one occurrence of the letter 'p' in the random three words Alyssa Cutthroat Kitchen Book scarf alchemy

Explanation / Answer

SELECT first_name,tv_show from info

where ( pick_integer < 10 OR pick_integer > 50)

AND three_words LIKE %p% ;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.