Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
CREATE TABLE BOOK ( id INT PRIMARY KEY, title VARCHAR(255), publication_year INT, genre VARCHAR(255), ISBN VARCHAR(255) ); CREATE TABLE AUTHOR ( id INT PRIMARY KEY, name VARCHAR(255), birth_date DATE ); CREATE TABLE BOOK_AUTHOR ( book_id INT, author_id INT, PRIMARY KEY (book_id, author_id), FOREIGN KEY (book_id) REFERENCES BOOK(id), FOREIGN KEY (author_id) REFERENCES AUTHOR(id) ); /** TASKS When was 'Pebble in the sky' published? Who was the author of the book titled 'Pebble in the sky' ? Show how many books each genre has! Which author has the most books? What is the title of the book that was republished the most amount of times? */
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
