CS257
Chris Pollett
Oct 19, 2020
Movie(title, year, length, genre, studioName, producerCertificateNo) Studio(name, address, presidentCertificateNo)Suppose a common query is:
SELECT title, year FROM Movie, Studio WHERE presidentCertificateNo = zzz AND Movie.studioName = Studio.name;
ALTER TABLE my_table ADD FULLTEXT(column1, column2,..)
Which of the following is true?
SELECT * FROM Points p WHERE NOT EXISTS( SELECT * FROM Points q WHERE (q.x-10.0)*(q.x-10.0) + (q.y-20.0)*(q.y-20.0) < (p.x-10.0)*(p.x-10.0) + (p.y-20.0)*(p.y-20.0) );