Question

Write a MySQL View to get the number of films acted by each actor. Your output should return the following..

First_Name, Last_Name, Total_films_acted

Answer 1

here i assume a table for example.

CREATE TABLE table1 (First_Name varchar(100),Last_Name varchar(100),films varchar(100));
INSERT INTO table1 (First_Name,Last_Name,films) VALUES ('kavya','tulabandula','abc');
INSERT INTO table1 (First_Name,Last_Name,films) VALUES ('kavya','1','abc');
INSERT INTO table1 (First_Name,Last_Name,films) VALUES ('kavya','tulabandula','a');
INSERT INTO table1 (First_Name,Last_Name,films) VALUES ('ganesh','tulabandula','abc');
INSERT INTO table1 (First_Name,Last_Name,films) VALUES ('aruna','tulabandula','abc');
INSERT INTO table1 (First_Name,Last_Name,films) VALUES ('kavya','tulabandula','xyz');

CREATE VIEW EXAMPLE AS SELECT First_Name,Last_Name,count(films) as Total_films_acted FROM table1 group by First_Name,Last_Name;
select * from EXAMPLE;