Primary Key, Partition Key, Clustering Key Quiz Two

CREATE TABLE heartrate_v7 ( 
   pet_chip_id uuid,
   time timestamp,
   heart_rate int, 
   pet_name text,
   PRIMARY KEY ((pet_chip_id, time), pet_name, heart_rate) );

SELECT * from heartrate_v7 WHERE pet_chip_id = 123e4567-e89b-12d3-a456-426655440b23 AND time ='2019-03-04 07:01:00';

CREATE TABLE heartrate_v7 ( 
   pet_chip_id uuid,
   time timestamp,
   heart_rate int, 
   pet_name text,
   PRIMARY KEY ((pet_chip_id, time), pet_name, heart_rate) );

SELECT * from heartrate_v7 WHERE pet_chip_id = 123e4567-e89b-12d3-a456-426655440b23;

CREATE TABLE heartrate_v7 ( 
   pet_chip_id uuid,
   time timestamp,
   heart_rate int, 
   pet_name text,
   PRIMARY KEY ((pet_chip_id, time), pet_name, heart_rate) );

SELECT * from heartrate_v7 WHERE pet_chip_id = 123e4567-e89b-12d3-a456-426655440b23 AND time ='2019-03-04 07:01:00' AND pet_name = 'Duke';

CREATE TABLE heartrate_v7 ( 
   pet_chip_id uuid,
   time timestamp,
   heart_rate int, 
   pet_name text,
   PRIMARY KEY ((pet_chip_id, time), pet_name, heart_rate) );

SELECT * from heartrate_v7 WHERE pet_chip_id = 123e4567-e89b-12d3-a456-426655440b23 AND time ='2019-03-04 07:01:00' AND pet_name = 'Duke' AND heart_rate = 100;

CREATE TABLE heartrate_v7 ( 
   pet_chip_id uuid,
   time timestamp,
   heart_rate int, 
   pet_name text,
   PRIMARY KEY ((pet_chip_id, time), pet_name, heart_rate) );


SELECT * from heartrate_v7 WHERE pet_chip_id = 123e4567-e89b-12d3-a456-426655440b23 AND time ='2019-03-04 07:01:00' AND heart_rate = 100;