Cassandra Query Language $($CQL$)$ Create and query tables. In this last step, you will create a couple of tables and add$/$delete$/$modify data. Please see Datastax documentation $)$ for variable$/$data types in Cassandra.

Create a table ShopByCustomer with following columns: customer id$,$ customer name, location item name and item price. Customer name and location make the primary key. Please note that Cassandra does not have JOINS or FOREIGN KEYS, you focus on queries while designing. In this example, customer name is clustering key and location is the partition key. Here, you primarily query records by customer name. Insert at least six or seven records, like:

$101,$ John Doe, Jacksonville, laptop, $299\mathrm{.}99103,$ Bill Jones, Orlando, iPad, $499\mathrm{.}99105,$ Sam Smith, Jacksonville, Monitor, $599\mathrm{.}99106,$ Natalie Johnso, Orlando, Samsung S$24,799\mathrm{.}99101,$ John Doe, Orlando, $65-$in TV$,1499\mathrm{.}99103,$ Bill Jones, Jacksonville, Monitor, $499\mathrm{.}99$

Now query the above table $($ShopByCustomer$)$ to list all dataQuery the above table to show records by a given customer name, like John DoeQuery the table to display the output by item name $($Please note for efficiency it may need additional clause ALLOW FILTERING to display the output. If you really want to look up data by item name, you would have another table for that purpose with the same data.$)$Query data for a customer $($e$.$g$.,$ John Doe$)$ and use order by location. Note, in a query a where clause with a column in the clustering key can be used so long as columns in the partition key are present in the where clause. Try the previous query and use order by item price.