Keith Miller keith44

## data.csv
valence,year,acousticness,artists,danceability,duration_ms,energy,explicit,id,instrumentalness,key,liveness,loudness,mode,name,popularity,release_date,speechiness,tempo
0.7240000000000001,1953,0.7859999999999999,['Doris Day & With Orchestra'],0.5579999999999999,128667,0.422,0,6g6IumW57HO2qaxZ2mt8Vo,0,0,0.218,-9.403,1,Just Blew In from the Windy City,30,19672,0.203,201.582
0.457,2003,0.000577,"['Too $hort', 'Lil Jon', 'Eastside Boyz']",0.937,278707,0.695,1,3XabgBQYC7H80agKcAq83Y,3.19e-05,0,0.295,-6.932,1,Shake That Monkey (feat. Lil' Jon & The EastSide Boyz),56,37622,0.134,99.997
0.464,2020,0.183,['Juice WRLD'],0.868,154767,0.55,1,0fCwrjKfWxF3xQhZrYUw4T,0,6,0.109,-6.417,1,Blood On My Jeans,79,44022,0.226,117.943
0.568,2020,0.0582,"['King Von', 'Polo G']",0.831,202413,0.62,1,5NOUjBikzECEJyZMTxtErD,0,6,0.119,-8.397,0,The Code (feat. Polo G),78,44134,0.338,133.17
0.877,1951,0.909,"['Marge Champion', 'Gower Champion']",0.667,196973,0.32299999999999995,0,6MMF38qO03XJ7puIxVl8Gg,0.0148,1,0.0301,-12.993,1,I Might Fall

## data.csv
valence,year,acousticness,artists,danceability,duration_ms,energy,explicit,id,instrumentalness,key,liveness,loudness,mode,name,popularity,release_date,speechiness,tempo
0.0594,1921,0.982,"['Sergei Rachmaninoff', 'James Levine', 'Berliner Philharmoniker']",0.279,831667,0.211,0,4BJqT0PrAfrxzMOxytFOIz,0.878,10,0.665,-20.096,1,"Piano Concerto No. 3 in D Minor, Op. 30: III. Finale. Alla breve",4,1921,0.0366,80.954
0.963,1921,0.732,['Dennis Day'],0.8190000000000001,180533,0.341,0,7xPhfUan2yNtyFG0cUWkt8,0,7,0.16,-12.441,1,Clancy Lowered the Boom,5,1921,0.415,60.93600000000001
0.0394,1921,0.961,['KHP Kridhamardawa Karaton Ngayogyakarta Hadiningrat'],0.328,500062,0.166,0,1o6I8BglA6ylDMrIELygv1,0.913,3,0.101,-14.85,1,Gati Bali,5,1921,0.0339,110.339
0.165,1921,0.967,['Frank Parker'],0.275,210000,0.309,0,3ftBPsC5vPBKxYSee08FDH,2.77e-05,5,0.381,-9.316,1,Danny Boy,3,1921,0.0354,100.109
0.253,1921,0.957,['Phil Regan'],0.418,166693,0.193,0,4d6HGyGT8e121BsdKmw9v6,1.68e-06,3,0.229,-10.096,1,When Irish Eyes Are Smiling,2,1921,0

## README.md

      
              2 files
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                keith44
                / README.md
            
            
              Last active
              February 25, 2026 03:25
            
              
                denver e-scooter usage metrics
              
          
    Data Source

Data obtained from Ride Report.
Data may be used with a link to https://public.ridereport.com and attribution to Ride Report.

  
## AirBnB_in_SanFran.sql
--What's the most expensive listing? What else can you tell me about the listing?
--100000

--id: 24650875
--name: Full House Victorian: 7500 SqFt, 4 Floors
--host_id: 6460979
--host_name: Sarah
--neighbourhood_group: no data
--neighbourhood: Western Addition
--latitude: 37.780230017385364

## SQL_data_access_methods.sql
SQL Basics Drill

# Selects the IDs and durations for all trips of duration greater than 500, ordered by duration.
SELECT
    trip_id,
	duration

FROM
    trips
WHERE
	valence,year,acousticness,artists,danceability,duration_ms,energy,explicit,id,instrumentalness,key,liveness,loudness,mode,name,popularity,release_date,speechiness,tempo
	0.7240000000000001,1953,0.7859999999999999,['Doris Day & With Orchestra'],0.5579999999999999,128667,0.422,0,6g6IumW57HO2qaxZ2mt8Vo,0,0,0.218,-9.403,1,Just Blew In from the Windy City,30,19672,0.203,201.582
	0.457,2003,0.000577,"['Too $hort', 'Lil Jon', 'Eastside Boyz']",0.937,278707,0.695,1,3XabgBQYC7H80agKcAq83Y,3.19e-05,0,0.295,-6.932,1,Shake That Monkey (feat. Lil' Jon & The EastSide Boyz),56,37622,0.134,99.997
	0.464,2020,0.183,['Juice WRLD'],0.868,154767,0.55,1,0fCwrjKfWxF3xQhZrYUw4T,0,6,0.109,-6.417,1,Blood On My Jeans,79,44022,0.226,117.943
	0.568,2020,0.0582,"['King Von', 'Polo G']",0.831,202413,0.62,1,5NOUjBikzECEJyZMTxtErD,0,6,0.119,-8.397,0,The Code (feat. Polo G),78,44134,0.338,133.17
	0.877,1951,0.909,"['Marge Champion', 'Gower Champion']",0.667,196973,0.32299999999999995,0,6MMF38qO03XJ7puIxVl8Gg,0.0148,1,0.0301,-12.993,1,I Might Fall
	valence,year,acousticness,artists,danceability,duration_ms,energy,explicit,id,instrumentalness,key,liveness,loudness,mode,name,popularity,release_date,speechiness,tempo
	0.0594,1921,0.982,"['Sergei Rachmaninoff', 'James Levine', 'Berliner Philharmoniker']",0.279,831667,0.211,0,4BJqT0PrAfrxzMOxytFOIz,0.878,10,0.665,-20.096,1,"Piano Concerto No. 3 in D Minor, Op. 30: III. Finale. Alla breve",4,1921,0.0366,80.954
	0.963,1921,0.732,['Dennis Day'],0.8190000000000001,180533,0.341,0,7xPhfUan2yNtyFG0cUWkt8,0,7,0.16,-12.441,1,Clancy Lowered the Boom,5,1921,0.415,60.93600000000001
	0.0394,1921,0.961,['KHP Kridhamardawa Karaton Ngayogyakarta Hadiningrat'],0.328,500062,0.166,0,1o6I8BglA6ylDMrIELygv1,0.913,3,0.101,-14.85,1,Gati Bali,5,1921,0.0339,110.339
	0.165,1921,0.967,['Frank Parker'],0.275,210000,0.309,0,3ftBPsC5vPBKxYSee08FDH,2.77e-05,5,0.381,-9.316,1,Danny Boy,3,1921,0.0354,100.109
	0.253,1921,0.957,['Phil Regan'],0.418,166693,0.193,0,4d6HGyGT8e121BsdKmw9v6,1.68e-06,3,0.229,-10.096,1,When Irish Eyes Are Smiling,2,1921,0
	--What's the most expensive listing? What else can you tell me about the listing?
	--100000

	--id: 24650875
	--name: Full House Victorian: 7500 SqFt, 4 Floors
	--host_id: 6460979
	--host_name: Sarah
	--neighbourhood_group: no data
	--neighbourhood: Western Addition
	--latitude: 37.780230017385364
	SQL Basics Drill

	# Selects the IDs and durations for all trips of duration greater than 500, ordered by duration.
	SELECT
	trip_id,
	duration

	FROM
	trips
	WHERE