{"id":1531,"date":"2022-11-08T23:03:22","date_gmt":"2022-11-08T15:03:22","guid":{"rendered":"https:\/\/qaqaq.top\/?p=1531"},"modified":"2022-11-27T12:40:58","modified_gmt":"2022-11-27T04:40:58","slug":"%e7%ac%ac9%e7%ab%a0%e5%ad%90%e6%9f%a5%e8%af%a2%e8%af%be%e5%90%8e%e7%bb%83%e4%b9%a01%e3%80%81%e7%ac%ac9%e7%ab%a0%e5%ad%90%e6%9f%a5%e8%af%a2%e8%af%be%e5%90%8e%e7%bb%83%e4%b9%a02","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=1531","title":{"rendered":"\u7b2c9\u7ae0\u5b50\u67e5\u8be2\u8bfe\u540e\u7ec3\u4e601\u3001\u7b2c9\u7ae0\u5b50\u67e5\u8be2\u8bfe\u540e\u7ec3\u4e602"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code># \u7b2c09\u7ae0_\u5b50\u67e5\u8be2\u8bfe\u540e\u7ec3\u4e60\r\n\r\n\r\n\r\n#1.\u67e5\u8be2\u548cZlotkey\u76f8\u540c\u90e8\u95e8\u7684\u5458\u5de5\u59d3\u540d\u548c\u5de5\u8d44\r\nSELECT last_name,salary\r\nFROM employees\r\nWHERE department_id IN (\r\n    SELECT department_id\r\n    FROM employees\r\n    WHERE last_name = 'Zlotkey'\r\n    );\r\n\r\n#2.\u67e5\u8be2\u5de5\u8d44\u6bd4\u516c\u53f8\u5e73\u5747\u5de5\u8d44\u9ad8\u7684\u5458\u5de5\u7684\u5458\u5de5\u53f7\uff0c\u59d3\u540d\u548c\u5de5\u8d44\u3002\r\nSELECT employee_id,last_name,salary\r\nFROM employees\r\nWHERE salary > (\r\n    SELECT AVG(salary)\r\n    FROM employees\r\n    );\r\n\r\n#3.\u9009\u62e9\u5de5\u8d44\u5927\u4e8e\u6240\u6709JOB_ID = 'SA_MAN'\u7684\u5458\u5de5\u7684\u5de5\u8d44\u7684\u5458\u5de5\u7684last_name, job_id, salary\r\nSELECT last_name,job_id,salary\r\nFROM employees\r\nWHERE salary > ALL(\r\n    SELECT salary\r\n    FROM employees\r\n    WHERE job_id = 'SA_MAN'\r\n    );\r\n\r\n#4.\u67e5\u8be2\u548c\u59d3\u540d\u4e2d\u5305\u542b\u5b57\u6bcdu\u7684\u5458\u5de5\u5728\u76f8\u540c\u90e8\u95e8\u7684\u5458\u5de5\u7684\u5458\u5de5\u53f7\u548c\u59d3\u540d\r\nSELECT employee_id,last_name\r\nFROM employees\r\nWHERE department_id IN (\r\n    SELECT DISTINCT department_id\r\n    FROM employees\r\n    WHERE last_name LIKE '%u%'\r\n    );\r\n\r\n#5.\u67e5\u8be2\u5728\u90e8\u95e8\u7684location_id\u4e3a1700\u7684\u90e8\u95e8\u5de5\u4f5c\u7684\u5458\u5de5\u7684\u5458\u5de5\u53f7\r\nSELECT employee_id\r\nFROM employees\r\nWHERE department_id IN (\r\n    SELECT department_id\r\n    FROM departments\r\n    WHERE location_id = 1700\r\n);\r\n\r\nDESC departments;\r\n\r\n#6.\u67e5\u8be2\u7ba1\u7406\u8005\u662fKing\u7684\u5458\u5de5\u59d3\u540d\u548c\u5de5\u8d44\r\nSELECT last_name,salary\r\nFROM employees\r\nWHERE manager_id IN (\r\n    SELECT employee_id\r\n    FROM employees\r\n    WHERE last_name = 'King'\r\n);\r\n\r\nSELECT emp.last_name,emp.salary\r\nFROM employees emp JOIN employees mgr\r\nON emp.manager_id = mgr.employee_id\r\nWHERE mgr.last_name = 'King';\r\n\r\n#7.\u67e5\u8be2\u5de5\u8d44\u6700\u4f4e\u7684\u5458\u5de5\u4fe1\u606f: last_name, salary\r\nSELECT last_name,salary\r\nFROM employees\r\nWHERE salary = (\r\n    SELECT MIN(salary)\r\n    FROM employees\r\n    );\r\n\r\n#8.\u67e5\u8be2\u5e73\u5747\u5de5\u8d44\u6700\u4f4e\u7684\u90e8\u95e8\u4fe1\u606f\r\n# \u65b9\u5f0f1\uff1a\r\n\r\nSELECT *\r\nFROM departments\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING AVG(salary) = (\r\n        SELECT MIN(avg_sal)\r\n        FROM(\r\n            SELECT AVG(salary) avg_sal\r\n            FROM employees\r\n            GROUP BY department_id\r\n            ) t_dept_avg_sal\r\n        )\r\n    );\r\n# \u65b9\u5f0f2\uff1a\r\n\r\nSELECT *\r\nFROM departments\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING AVG(salary) &lt;= ALL (\r\n        SELECT AVG(salary)\r\n        FROM employees\r\n        GROUP BY department_id\r\n        )\r\n    );\r\n\r\n# \u65b9\u5f0f3\uff1aLIMIT\r\n\r\nSELECT *\r\nFROM departments\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING AVG(salary) = (\r\n        SELECT AVG(salary) avg_sal\r\n        FROM employees\r\n        GROUP BY department_id\r\n        ORDER BY avg_sal ASC\r\n        LIMIT 1\r\n        )\r\n    );\r\n\r\n# \u65b9\u5f0f4\uff1a\r\n\r\nSELECT d.*\r\nFROM departments d ,(\r\n           SELECT department_id,AVG(salary) avg_sal\r\n            FROM employees\r\n            GROUP BY department_id\r\n            ORDER BY avg_sal ASC\r\n            LIMIT 0,1\r\n    ) t_dept_avg_sal\r\nWHERE d.department_id = t_dept_avg_sal.department_id;\r\n\r\n#9.\u67e5\u8be2\u5e73\u5747\u5de5\u8d44\u6700\u4f4e\u7684\u90e8\u95e8\u4fe1\u606f\u548c\u8be5\u90e8\u95e8\u7684\u5e73\u5747\u5de5\u8d44\uff08\u76f8\u5173\u5b50\u67e5\u8be2\uff09\r\n# \u65b9\u5f0f1\uff1a\r\n\r\nSELECT d.*,(SELECT AVG(salary) FROM employees WHERE d.department_id = d.department_id) avg_sal\r\nFROM departments d\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING AVG(salary) = (\r\n        SELECT MIN(avg_sal)\r\n        FROM(\r\n            SELECT AVG(salary) avg_sal\r\n            FROM employees\r\n            GROUP BY department_id\r\n            ) t_dept_avg_sal\r\n        )\r\n    );\r\n# \u65b9\u5f0f2\uff1a\r\n\r\nSELECT d.*,(SELECT AVG(salary) FROM employees WHERE department_id = d.department_id) avg_sal\r\nFROM departments d\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING AVG(salary) &lt;= ALL (\r\n        SELECT AVG(salary)\r\n        FROM employees\r\n        GROUP BY department_id\r\n        )\r\n    );\r\n\r\n# \u65b9\u5f0f3\uff1aLIMIT\r\n\r\nSELECT d.*,(SELECT AVG(salary) FROM employees WHERE department_id = d.department_id) avg_sal\r\nFROM departments d\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING AVG(salary) = (\r\n        SELECT AVG(salary) avg_sal\r\n        FROM employees\r\n        GROUP BY department_id\r\n        ORDER BY avg_sal ASC\r\n        LIMIT 1\r\n        )\r\n    );\r\n\r\n# \u65b9\u5f0f4\uff1a\r\n\r\nSELECT d.*,(SELECT AVG(salary) FROM employees WHERE department_id = d.department_id) avg_sal\r\nFROM departments d ,(\r\n           SELECT department_id,AVG(salary) avg_sal\r\n            FROM employees\r\n            GROUP BY department_id\r\n            ORDER BY avg_sal ASC\r\n            LIMIT 0,1\r\n    ) t_dept_avg_sal\r\nWHERE d.department_id = t_dept_avg_sal.department_id;\r\n\r\n#10.\u67e5\u8be2\u5e73\u5747\u5de5\u8d44\u6700\u9ad8\u7684 job \u4fe1\u606f\r\n\r\n# \u65b9\u5f0f1\uff1a\r\nSELECT *\r\nFROM jobs\r\nWHERE job_id = (\r\n    SELECT job_id\r\n    FROM employees\r\n    GROUP BY job_id\r\n    HAVING AVG(salary) = (\r\n        SELECT MAX(avg_sal)\r\n        FROM (\r\n            SELECT AVG(salary) avg_sal\r\n            FROM employees\r\n            GROUP BY job_id\r\n             ) t_job_avg_sak\r\n        )\r\n    );\r\n\r\n# \u65b9\u5f0f2:\r\n\r\nSELECT *\r\nFROM jobs\r\nWHERE job_id = (\r\n    SELECT job_id\r\n    FROM employees\r\n    GROUP BY job_id\r\n    HAVING AVG(salary) >= ALL (\r\n        SELECT AVG(salary)\r\n        FROM employees\r\n        GROUP BY job_id\r\n        )\r\n    );\r\n\r\n# \u65b9\u5f0f3:\r\n# \u65b9\u5f0f2:\r\n\r\nSELECT *\r\nFROM jobs\r\nWHERE job_id = (\r\n    SELECT job_id\r\n    FROM employees\r\n    GROUP BY job_id\r\n    HAVING AVG(salary) = (\r\n        SELECT AVG(salary) avg_sal\r\n        FROM employees\r\n        GROUP BY job_id\r\n        ORDER BY avg_sal DESC\r\n        LIMIT 0,1\r\n        )\r\n    );\r\n\r\n# \u65b9\u5f0f4:\r\nSELECT j.*\r\nFROM jobs j, (\r\n    SELECT job_id,AVG(salary) avg_sal\r\n    FROM employees\r\n    GROUP BY job_id\r\n    ORDER BY avg_sal DESC\r\n    LIMIT 0,1\r\n    ) t_job_avg_sal\r\nWHERE j.job_id = t_job_avg_sal.job_id;\r\n\r\n\r\n#11.\u67e5\u8be2\u5e73\u5747\u5de5\u8d44\u9ad8\u4e8e\u516c\u53f8\u5e73\u5747\u5de5\u8d44\u7684\u90e8\u95e8\u6709\u54ea\u4e9b?\r\nSELECT department_id\r\nFROM employees\r\nWHERE department_id IS NOT NULL\r\nGROUP BY  department_id\r\nHAVING AVG(salary) > (\r\n    SELECT AVG(salary)\r\n    FROM employees\r\n    );\r\n\r\n#12.\u67e5\u8be2\u51fa\u516c\u53f8\u4e2d\u6240\u6709 manager \u7684\u8be6\u7ec6\u4fe1\u606f\r\n\r\n#\u65b9\u5f0f1: \u81ea\u8fde\u63a5 xxx worked for yyy\r\nSELECT DISTINCT mgr.employee_id,mgr.last_name,mgr.job_id,mgr.department_id\r\nFROM employees emp JOIN employees mgr\r\nON emp.manager_id = mgr.employee_id;\r\n\r\n#\u65b9\u5f0f2\uff1a\u5b50\u67e5\u8be2\r\nSELECT employee_id,last_name,job_id,department_id\r\nFROM employees\r\nWHERE employee_id IN (\r\n    SELECT DISTINCT manager_id\r\n    FROM employees\r\n    );\r\n\r\n#\u65b9\u5f0f3\uff1a\u4f7f\u7528EXISTS\r\nSELECT employee_id,last_name,job_id,department_id\r\nFROM employees e1\r\nWHERE EXISTS(\r\n    SELECT *\r\n    FROM employees e2\r\n    WHERE e1.employee_id = e2.manager_id\r\n          );\r\n\r\n#13.\u5404\u4e2a\u90e8\u95e8\u4e2d \u6700\u9ad8\u5de5\u8d44\u4e2d\u6700\u4f4e\u7684\u90a3\u4e2a\u90e8\u95e8\u7684 \u6700\u4f4e\u5de5\u8d44\u662f\u591a\u5c11?\r\n#\u65b9\u5f0f1\uff1a\r\n\r\nSELECT MIN(salary)\r\nFROM employees\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING MAX(salary) = (\r\n        SELECT MIN(max_sal)\r\n        FROM (\r\n            SELECT MAX(salary) max_sal\r\n            FROM employees\r\n            GROUP BY department_id\r\n             ) t_dept_max_sal\r\n        )\r\n    );\r\n\r\nSELECT *\r\nFROM employees\r\nWHERE department_id = 10;\r\n\r\n#\u65b9\u5f0f2:\r\nSELECT MIN(salary)\r\nFROM employees\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING MAX(salary) &lt;= ALL (\r\n        SELECT MAX(salary)\r\n        FROM employees\r\n        GROUP BY department_id\r\n        )\r\n    );\r\n\r\n#\u65b9\u5f0f3:\r\nSELECT MIN(salary)\r\nFROM employees\r\nWHERE department_id = (\r\n    SELECT department_id\r\n    FROM employees\r\n    GROUP BY department_id\r\n    HAVING MAX(salary) = (\r\n        SELECT MAX(salary) max_sal\r\n        FROM employees\r\n        GROUP BY department_id\r\n        ORDER BY max_sal ASC\r\n        LIMIT 0,1\r\n        )\r\n    );\r\n\r\n#\u65b9\u5f0f4:\r\nSELECT MIN(salary)\r\nFROM employees e,(\r\n    SELECT department_id,MAX(salary) max_sal\r\n    FROM employees\r\n    GROUP BY department_id\r\n    ORDER BY max_sal ASC\r\n    LIMIT 0,1\r\n    ) t_dept_max_sal\r\nWHERE e.department_id = t_dept_max_sal.department_id;\r\n\r\n\r\n#14.\u67e5\u8be2\u5e73\u5747\u5de5\u8d44\u6700\u9ad8\u7684\u90e8\u95e8\u7684 manager \u7684\u8be6\u7ec6\u4fe1\u606f: last_name, department_id, email, salary\r\n#\u65b9\u5f0f1:\r\n\r\nSELECT last_name,department_id,email,salary\r\nFROM employees\r\nWHERE employee_id = ANY (\r\n    SELECT DISTINCT manager_id\r\n    FROM employees\r\n    WHERE department_id = (\r\n        SELECT department_id\r\n        FROM employees\r\n        GROUP BY department_id\r\n        HAVING AVG(salary) = (\r\n            SELECT MAX(avg_sal)\r\n            FROM (\r\n                SELECT AVG(salary) avg_sal\r\n                FROM employees\r\n                GROUP BY department_id\r\n                 ) t_dept_avg_sal\r\n            )\r\n        )\r\n    );\r\n\r\n#\u65b9\u5f0f2:\r\n\r\nSELECT last_name,department_id,email,salary\r\nFROM employees\r\nWHERE employee_id = ANY (\r\n    SELECT DISTINCT manager_id\r\n    FROM employees\r\n    WHERE department_id = (\r\n        SELECT department_id\r\n        FROM employees\r\n        GROUP BY department_id\r\n        HAVING AVG(salary) >= ALL (\r\n            SELECT AVG(salary)\r\n            FROM employees\r\n            GROUP BY department_id\r\n            )\r\n        )\r\n    );\r\n\r\n#\u65b9\u5f0f3:\r\n\r\nSELECT last_name,department_id,email,salary\r\nFROM employees\r\nWHERE employee_id IN (\r\n    SELECT DISTINCT manager_id\r\n    FROM employees e, (\r\n        SELECT department_id,AVG(salary) avg_sal\r\n        FROM employees\r\n        GROUP BY department_id\r\n        ORDER BY avg_sal DESC\r\n        LIMIT 0,1\r\n        ) t_dept_avg_sal\r\n    WHERE e.department_id = t_dept_avg_sal.department_id\r\n    );\r\n\r\n#15. \u67e5\u8be2\u90e8\u95e8\u7684\u90e8\u95e8\u53f7\uff0c\u5176\u4e2d\u4e0d\u5305\u62ecjob_id\u662f\"ST_CLERK\"\u7684\u90e8\u95e8\u53f7\r\n#\u65b9\u5f0f1:\r\n\r\nSELECT department_id\r\nFROM departments\r\nWHERE department_id NOT IN (\r\n    SELECT DISTINCT department_id\r\n    FROM employees\r\n    WHERE job_id = 'ST_CLERK'\r\n    );\r\n\r\n#\u65b9\u5f0f2:\r\n\r\nSELECT department_id\r\nFROM departments d\r\nWHERE NOT EXISTS(\r\n    SELECT *\r\n    FROM employees e\r\n    WHERE d.department_id = e.department_id\r\n    AND e.job_id = 'ST_CLERK'\r\n          );\r\n\r\n#16. \u9009\u62e9\u6240\u6709\u6ca1\u6709\u7ba1\u7406\u8005\u7684\u5458\u5de5\u7684last_name\r\nSELECT last_name\r\nFROM employees emp\r\nWHERE NOT EXISTS(\r\n    SELECT *\r\n    FROM employees mgr\r\n    WHERE emp.manager_id = mgr.employee_id\r\n          );\r\n\r\n#17\uff0e\u67e5\u8be2\u5458\u5de5\u53f7\u3001\u59d3\u540d\u3001\u96c7\u7528\u65f6\u95f4\u3001\u5de5\u8d44\uff0c\u5176\u4e2d\u5458\u5de5\u7684\u7ba1\u7406\u8005\u4e3a 'De Haan'\r\n#\u65b9\u5f0f1:\r\n\r\nSELECT employee_id,last_name,hire_date,salary\r\nFROM employees\r\nWHERE manager_id IN (\r\n    SELECT employee_id\r\n    FROM employees\r\n    WHERE last_name = 'De Haan'\r\n    );\r\n\r\n#\u65b9\u5f0f2:\r\nSELECT employee_id,last_name,hire_date,salary\r\nFROM employees emp\r\nWHERE EXISTS(\r\n    SELECT *\r\n    FROM employees mgr\r\n    WHERE emp.manager_id = mgr.employee_id\r\n    AND mgr.last_name = 'De Haan'\r\n          );\r\n\r\n#18.\u67e5\u8be2\u5404\u90e8\u95e8\u4e2d\u5de5\u8d44\u6bd4\u672c\u90e8\u95e8\u5e73\u5747\u5de5\u8d44\u9ad8\u7684\u5458\u5de5\u7684\u5458\u5de5\u53f7, \u59d3\u540d\u548c\u5de5\u8d44\uff08\u76f8\u5173\u5b50\u67e5\u8be2\uff09\r\n\r\n#\u65b9\u5f0f1:\u4f7f\u7528\u76f8\u5173\u5b50\u67e5\u8be2\r\n\r\nSELECT employee_id,last_name,salary\r\nFROM employees e1\r\nWHERE salary > (\r\n    SELECT AVG(salary)\r\n    FROM employees e2\r\n    WHERE e1.department_id = e2.department_id\r\n    );\r\n\r\n#\u65b9\u5f0f2:\u5728FROM\u4e2d\u58f0\u660e\u5b50\u67e5\u8be2\r\n\r\nSELECT employee_id,last_name,salary\r\nFROM employees e ,(\r\n    SELECT department_id,AVG(salary) avg_sal\r\n    FROM employees\r\n    GROUP BY department_id\r\n    ) t_dept_avg_sal\r\nWHERE e.department_id = t_dept_avg_sal.department_id\r\nAND e.salary > t_dept_avg_sal.avg_sal;\r\n\r\n#19.\u67e5\u8be2\u6bcf\u4e2a\u90e8\u95e8\u4e0b\u7684\u90e8\u95e8\u4eba\u6570\u5927\u4e8e 5 \u7684\u90e8\u95e8\u540d\u79f0\uff08\u76f8\u5173\u5b50\u67e5\u8be2\uff09\r\nSELECT department_name\r\nFROM departments d\r\nWHERE 5 &lt; (\r\n    SELECT COUNT(*)\r\n    FROM employees e\r\n    WHERE d.department_id = e.department_id\r\n    );\r\n\r\n#20.\u67e5\u8be2\u6bcf\u4e2a\u56fd\u5bb6\u4e0b\u7684\u90e8\u95e8\u4e2a\u6570\u5927\u4e8e 2 \u7684\u56fd\u5bb6\u7f16\u53f7\uff08\u76f8\u5173\u5b50\u67e5\u8be2\uff09\r\n\r\nSELECT * FROM locations;\r\n\r\nSELECT country_id\r\nFROM locations l\r\nWHERE 2 &lt; (\r\n    SELECT COUNT(*)\r\n    FROM departments d\r\n    WHERE l.location_id = d.location_id\r\n    )\r\n\/*\r\n \u5b50\u67e5\u8be2\u7684\u7f16\u5199\u6280\u5de7\uff08\u6216\u6b65\u9aa4\uff09\uff1a\u2460 \u4ece\u91cc\u5f80\u5916\u5199  \u2461 \u4ece\u5916\u5f80\u91cc\u5199\r\n\r\n \u5982\u4f55\u9009\u62e9?\r\n \u2460 \u5982\u679c\u5b50\u67e5\u8be2\u76f8\u5bf9\u8f83\u7b80\u5355,\u5efa\u8bae\u4ece\u5916\u5f80\u91cc\u5199\u3002\u4e00\u65e6\u5b50\u67e5\u8be2\u7ed3\u6784\u8f83\u590d\u6742\uff0c\u5219\u5efa\u8bae\u4ece\u91cc\u5f80\u5916\u5199\r\n \u2461 \u5982\u679c\u662f\u76f8\u5173\u5b50\u67e5\u8be2\u7684\u8bdd\uff0c\u901a\u5e38\u90fd\u662f\u4ece\u5916\u5f80\u91cc\u5199\u3002\r\n *\/\r\n\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[47],"class_list":["post-1531","post","type-post","status-publish","format-standard","hentry","category-mysql-code","tag-mysql"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1531"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1531"}],"version-history":[{"count":1,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1531\/revisions"}],"predecessor-version":[{"id":1532,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1531\/revisions\/1532"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}