asimov | Automatically exclude development dependencies from Apple | Continuous Backup library

I'm stuck on a problem that should be simple. Suppose I have two tables: authors and books. For this example we will assume that a book has only one author. I'd like to have a report that expresses the amount authors having written x books, e.g:

...

The thing is that when I (outer) join the books and authors I get NULL values for the books.

My best approach was to do it in two queries, one with a inner join so I exclude the authors not having written a book yet and then I add the count of them programmatically.

Here's my query

I have this dataframe in r (link) (Example rows and columns below)

I am learning JSON function in mariaDB where I have

CREATE TABLE IF NOT EXISTS products ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, type VARCHAR(1) NOT NULL, name VARCHAR(40) NOT NULL, format VARCHAR(20) NOT NULL, price FLOAT(5, 2) NOT NULL, attr JSON NOT NULL)

INSERT INTO products (type, name, format, price, attr) VALUES ('M', 'Aliens', 'Blu-ray', 13.99,'{"video": {"resolution": "1080p", "aspectRatio": "1.85:1"}, "cuts": [{"name": "Theatrical", "runtime": 138}, {"name":"Special Edition", "runtime": 155}], "audio": ["DTS HD", "Dolby Surround"]}'); INSERT INTO products (type, name, format, price, attr) VALUES ('B', 'Foundation', 'Paperback', 7.99, '{"author": "Isaac Asimov", "page_count": 296}');

I want to find how many records are there where Cuts.name="Theatrical"

Something is wrong when I try to find the person who has the closest Age to Sonya Sotomayor. Can anyone detect my error?

So I have an entire program below that creates Book objects, initializes them, and prints any constructors/destructors that are created or destroyed throughout the execution of the program.

I have ran my code (and pasted the output below), and I am having trouble understanding how the destructors are being called. So I know that the constructors are destroyed in the opposite order in which they were created. But I don't get why four of the destructor statements have an id of 4. I'm assuming one came from the "explicit call to the copy constructor", the other came from "declaring and initializing book 6 from book 5", and the other came from the first part of "declaring and initializing books 1 to 4." But I'm confused as to where the extra id of 4 came from?

Additionally, I was wondering why a "-- dtor: 0" wasn't printed for the "declaring book 5" part where default ctor: 0 was created.

I would really appreciate any clarification!

main.cc:

I am a beginner to C, and essentially, I am trying to read a file char by char, and echo the characters to the output, but also, at the start of every line, include the line number. I have managed to figure out how to count the lines, but when I attempt to insert the line number, I can't figure out how to get it to insert on the next line, rather than immediately upon encountering the newline.

Here is my code: