Books with NULL Ratings
[]
['Create table books (\n    book_id int,\n    title varchar(255),\n    author varchar(100),\n    published_year int,\n    rating decimal(3,1)\n)', 'Truncate table books', "insert into books (book_id, title, author, published_year, rating) values ('1', 'The Great Gatsby', 'F. Scott', '1925', '4.5')", "insert into books (book_id, title, author, published_year, rating) values ('2', 'To Kill a Mockingbird', 'Harper Lee', '1960', NULL)", "insert into books (book_id, title, author, published_year, rating) values ('3', 'Pride and Prejudice', 'Jane Austen', '1813', '4.8')", "insert into books (book_id, title, author, published_year, rating) values ('4', 'The Catcher in the Rye', 'J.D. Salinger', '1951', NULL)", "insert into books (book_id, title, author, published_year, rating) values ('5', 'Animal Farm', 'George Orwell', '1945', '4.2')", "insert into books (book_id, title, author, published_year, rating) values ('6', 'Lord of the Flies', 'William Golding', '1954', NULL)"]
{"mysql": ["Create table books (\n    book_id int,\n    title varchar(255),\n    author varchar(100),\n    published_year int,\n    rating decimal(3,1)\n)"], "mssql": ["Create table books (\n    book_id int,\n    title varchar(255),\n    author varchar(100),\n    published_year int,\n    rating decimal(3,1)\n)"], "oraclesql": ["Create table books (\n    book_id number,\n    title varchar2(255),\n    author varchar2(100),\n    published_year number,\n    rating number(3,1)\n)"], "database": true, "name": "find_unrated_books", "postgresql": ["CREATE TABLE books (\n    book_id INTEGER,\n    title VARCHAR(255),\n    author VARCHAR(100),\n    published_year INTEGER,\n    rating NUMERIC(3, 1)\n);\n"], "pythondata": ["books = pd.DataFrame({ \"book_id\": pd.Series(dtype=\"int\"), \"title\": pd.Series(dtype=\"str\"), \"author\": pd.Series(dtype=\"str\"), \"published_year\": pd.Series(dtype=\"int\"), \"rating\": pd.Series(dtype=\"float\") })\n"], "database_schema": {"books": {"book_id": "INT", "title": "VARCHAR(255)", "author": "VARCHAR(100)", "published_year": "INT", "rating": "DECIMAL(3, 1)"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']