Workspace
Raghavareddy Malireddy/

Course Notes: Introduction to SQL Server

0
Beta
Spinner

add text here

In the SQL cell below:

  • Set the source to 'Course Databases' to query databases used in SQL courses.
  • Set the source to 'DataFrames and CSVs' to query this course's CSV files (if any) with SQL
  • Write SQL! Note that you cannot run queries that modify the database.
Unknown integration
Queryavailable as
query
variable
-- Select the details and location of different events
-- Note that the query may take a long time to run if you remove the LIMIT statement
SELECT eventname,
        catname,
        venuecity,
        caldate
FROM event
  INNER JOIN date USING(dateid)
    INNER JOIN category USING(catid)
    INNER JOIN venue USING(venueid)
ORDER BY caldate
LIMIT 5
  • AI Chat
  • Code