NYT Bestsellers and Goodreads Ratings Database

Sample queries


Visualisations

Bar Chart

To produce a bar chart, write a query whith a SELECT list which mentions two columns. The values in the first column specify the labels to be used for the bars. The second column needs to provide the numbers which can determine the length of the bars.

Sample query




Line Chart

To create a line chart, write an SQL query with a SELECT list containing two columns. The values of the first column will be shown on the X-axis and the values of the second column on the Y-axis.

Sample query




Scatter plot

The text box below can be used to generate a scatter plot. The SELECT list of the SQL query that you type in needs to refer to two columns. The values in the first column will be show on the X-axis, and the values in the second columns will be shown on the Y-axis. Both columns need to contain numeric values.

Sample query