SELECT name name_category, COUNT(fa.film_id) total_films
FROM
(SELECT film_id
FROM film_actor
WHERE actor_id IN

su
mkdir -p /data/adb/modules/mybin/system/bin
cd /data/adb/modules/mybin/system/bin

echo $0

{
status: 'Success',
method: 'server',
maindata: '9f9b3015b8be909b140ad79066ec95c19468a0b6c1a4a7488896361e85e5146d408600501750c81a08eed42cea16847acd7528d6048e2e33be4eac86dcd98dda86f1281fc0053aec71f4308a41490a9abc5566b8f3121171cd8f93f9816c0263019a34a5c61e6401dfbd541875803f3aac24b33e9595cf887a89afe190eafb29',
otherdata: [

{
"ip": {
"112.216.180.155": 16368,
"46.4.72.171": 5978,
"5.9.156.18": 5813,

SELECT name name_category, COUNT(fa.film_id) total_films
FROM
(SELECT film_id
FROM film_actor
WHERE actor_id IN

(SELECT film_id
FROM film_actor
WHERE actor_id IN
(SELECT actor_id
FROM film_actor

{
"ip": {
"112.216.180.155": 16367,
"46.4.72.171": 5978,
"5.9.156.18": 5813,

#include <iostream>
#include <queue>
#include <cstring>
#include <vector>

SELECT EXTRACT(YEAR
FROM CAST(invoice_date AS date)) ,
MIN(total),
MAX(total),
SUM(total),

{
"ip": {
"112.214.84.13": 668,
"144.76.163.231": 5745,
"46.4.74.132": 5909,