cyclist_cat_pts
Track cyclists by category and point total.
Track cyclists by category and point total.
// Track cyclists by category and point total
source '0_create_keyspace.cql';
// CREATE TABLE CATEGORIZED POINTS
DROP TABLE IF EXISTS cycling.cyclist_cat_pts;
// START-table
CREATE TABLE cycling.cyclist_cat_pts (
category text,
points int,
id UUID,
lastname text,
PRIMARY KEY (category, points));
// END-table
// START-inserts
INSERT INTO cycling.cyclist_cat_pts (category, points, id, lastname) VALUES
('GC', 780, 829aa84a-4bba-411f-a4fb-38167a987cda, 'SUTHERLAND');
INSERT INTO cycling.cyclist_cat_pts (category, points, id, lastname) VALUES
('GC', 1269, 220844bf-4860-49d6-9a4b-6b5d3a79cbfb, 'TIRALONGO');
// END-inserts
// Query to view inserted data
// To fine tune the display order, use the ORDER BY clause
// The partition key must be defined in the WHERE clause
// The ORDER BY clause defines the clustering column to use
SELECT * FROM cycling.cyclist_cat_pts WHERE category = 'GC' ORDER BY points ASC;