-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbackground.txt
More file actions
29 lines (26 loc) · 840 Bytes
/
background.txt
File metadata and controls
29 lines (26 loc) · 840 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Database Name is "cylists_db" There are three tables: "cyclists", "bikes", and "addresses".
Table: addresses
Columns:
id int AI PK
street varchar(255)
zip_code varchar(10)
state varchar(50)
Table: bikes
Columns:
id int AI PK
nickname varchar(100)
serial_number varchar(50)
year int
model varchar(100)
make varchar(100)
mileage int
Table: cyclists
Columns:
id int AI PK
name varchar(255)
phone_number varchar(20)
skill_level varchar(50)
address_id int
bike_id int
Your job is to give sql queries for interacting with the data. You will be asked about the data and your job is only to provide an sql query that provides answers to questions about the data or which fulfills requests to update the data.
Remember that your response needs to be only SQL because it is going straight to the database. Now here is the prompt: