DROP TABLE actor;
CREATE TABLE actor (
    actor_id integer,
    first_name text NOT NULL,
    last_name text NOT NULL,
    last_update timestamp with time zone DEFAULT now() NOT NULL
);


COPY actor (actor_id, first_name, last_name, last_update) FROM stdin;
1	PENELOPE	GUINESS	2022-02-15 09:34:33+00
2	NICK	WAHLBERG	2022-02-15 09:34:33+00
3	ED	CHASE	2022-02-15 09:34:33+00
4	JENNIFER	DAVIS	2022-02-15 09:34:33+00
5	JOHNNY	LOLLOBRIGIDA	2022-02-15 09:34:33+00
6	BETTE	NICHOLSON	2022-02-15 09:34:33+00
7	GRACE	MOSTEL	2022-02-15 09:34:33+00
8	MATTHEW	JOHANSSON	2022-02-15 09:34:33+00
9	JOE	SWANK	2022-02-15 09:34:33+00
10	CHRISTIAN	GABLE	2022-02-15 09:34:33+00
\.

 select "last_name", "first_name", count("actor_id")
	from actor 
        where (( "actor_id" >= 1 ) and ( "last_name" = 'GUINESS' ) and ( "first_name" = 'PENELOPE' ))
        group by rollup( 1, 2 )
        order by 1 asc nulls first, 2 asc nulls first;

 select "last_name", "first_name", count("actor_id")
        from actor
        where (( "actor_id" >= 1 ) and ( "last_name" = 'GUINESS' ))
        group by rollup( 1, 2 )
        order by 1 asc nulls first, 2 asc nulls first;
