Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

While in a hackathon at your high school, the instructor had to remove students with scores under 6 0 points. 6 0 is a number.

While in a hackathon at your high school, the instructor had to remove students with scores under 60 points. 60 is a number. The following is a sample of the scores.
Hackathon Table:
ID Student Name Score
4367 Jane Smith 70
4756 Samuel Heart 56
8789 Kim Parker 97
What is the correct SQL to delete those students with scores under 60 points?
Question 9 options:
DELETE FROM HACKATHON WHERE SCORE <'60';
DELETE FROM HACKATHON WHERE SCORE <60;
DELETE WHERE SCORE =60;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Web Database Development Step By Step

Authors: Jim Buyens

1st Edition

0735609667, 978-0735609662

More Books

Students also viewed these Databases questions

Question

How will these issues affect the grade levels you will teach?

Answered: 1 week ago