Partition by range example

- [Instructor] Let's see how we create a table … using range partitioning. … We'll use the IoT table example we discussed … in the previous video. … So, let's issue the CREATE TABLE command … and that will start off with CREATE TABLE, … so it's no different than we usually create a table, … so we'll give it a name … and I'll call this iot_measurement … and now we'll specify our columns. … Let's see, I want a location, … we'll assume have a location_id … and I'll make sure that's an int … and I don't want that to be null. … Next, I'll add a measure_date … and that of course will be of type date … and that has to be not null as well … and we want to know what the temp is, … so we'll record the temperature in Celsius … and we'll assume that's just an int … and that could be null … and let's get the relative humidity. … And let's assume that's an int as well. … So, this is the basics of creating a table … but we want a partition table, … so we're going to add the phrase PARTITION BY … and we want to specify PARTITION BY RANGE …