25rows
6 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
title | | yes | — | — |
au_ord | | yes | — | — |
au_lname | | yes | — | — |
price | | yes | — | — |
ytd_sales | | yes | — | — |
pub_id | | yes | — | — |
View definition
CREATE VIEW titleview AS select title, au_ord, au_lname, price, ytd_sales, pub_id from authors, titles, titleauthor where authors.au_id = titleauthor.au_id AND titles.title_id = titleauthor.title_idData preview
Sample records
| title | au_ord | au_lname | price | ytd_sales | pub_id |
|---|---|---|---|---|---|
| But Is It User Friendly? | 1 | Carson | 22.95 | 8780 | 1389 |
| Computer Phobic AND Non-Phobic Individuals: Behavior Variations | 1 | Karsen | 21.59 | 375 | 0877 |
| Computer Phobic AND Non-Phobic Individuals: Behavior Variations | 2 | MacFeather | 21.59 | 375 | 0877 |
| Cooking with Computers: Surreptitious Balance Sheets | 1 | MacFeather | 11.95 | 3876 | 1389 |
| Cooking with Computers: Surreptitious Balance Sheets | 2 | O'Leary | 11.95 | 3876 | 1389 |
| Emotional Security: A New Algorithm | 1 | Locksley | 7.99 | 3336 | 0736 |
| Fifty Years in Buckingham Palace Kitchens | 1 | Blotchet-Halls | 11.95 | 15096 | 0877 |
| Is Anger the Enemy? | 1 | Ringer | 10.95 | 2045 | 0736 |