How to create sample tables with Data referred in Reference Manual

[Max Marwan]

Hello

I am newby to mysql. How do I create the tables ( with data ) that are referred in mysql 8.0 Reference Manaual.

Some examples I found are as follows...

mysql> SELECT owner, COUNT(*) FROM pet;

mysql>SELECT o.custid, c.name, MAX(o.payment)
FROM orders AS o, customers AS c
WHERE o.custid = c.custid
GROUP BY o.custid;

mysql> SELECT
val,
ROW_NUMBER() OVER w AS 'row_number',
CUME_DIST() OVER w AS 'cume_dist',
PERCENT_RANK() OVER w AS 'percent_rank'
FROM numbers
WINDOW w AS (ORDER BY val);


there are also reference to other tables as well , like observations,series , orders, sales

In my google search, I found employees, northwind, sakila etc but none of them seems to have all the tables referred here.

Can someone help

Thanks.