{"id":45966,"date":"2018-12-19T17:05:39","date_gmt":"2018-12-19T11:35:39","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=45966"},"modified":"2018-12-19T17:07:59","modified_gmt":"2018-12-19T11:37:59","slug":"sql-query-interview-questions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/","title":{"rendered":"SQL Query Interview Questions &#8211; Practice All Types of SQL Queries"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1703,&quot;href&quot;:&quot;http:\\\/\\\/sql.org&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251209181053\\\/https:\\\/\\\/sql.org\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 10:47:39&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-26 16:46:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-08 09:28:34&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-17 10:32:22&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-27 09:19:16&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-02 15:27:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-07 04:18:51&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-13 06:26:25&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-19 12:46:02&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-27 16:01:49&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-25 15:24:12&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-02 06:09:40&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-13 09:51:05&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-17 11:53:49&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-11 19:40:57&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-26 15:14:01&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-05-26 15:14:01&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h2>1. Most Asked SQL Query Interview Questions<\/h2>\n<p>Earlier we have discussed the different types of <strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-interview-questions\/\">SQL questions asked in the interview<\/a><\/strong>. Today, we will focus on a particular type and that is SQL Query Interview Questions. So, in this blog, you will find the interview questions based on complex SQL queries that you can practice online. First, we have provided you with a sample table which you will prepare through the SQL queries. Also, we have given how to prepare these SQL tables through different queries. And finally, you will see the most asked SQL Query interview Questions with Answers which will help you to crack your upcoming SQL interview.<\/p>\n<p>So, let&#8217;s start the tutorial by creating a table in SQL.<\/p>\n<div id=\"attachment_46007\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46007\" class=\"size-full wp-image-46007\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg\" alt=\"SQL Query Interview Questions - Practice All Type of SQL Queries\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-46007\" class=\"wp-caption-text\">SQL Query Interview Questions &#8211; Practice All Type of SQL Queries<\/p><\/div>\n<h2>2. How to Create Table in SQL?<\/h2>\n<p>Below are the <strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-create-table\/\">tables which you will create<\/a> <\/strong>through the SQL queries.<\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">WORKER_ID<\/span><\/td>\n<td><span style=\"font-weight: 400\">FIRST_NAME<\/span><\/td>\n<td><span style=\"font-weight: 400\">LAST_NAME<\/span><\/td>\n<td><span style=\"font-weight: 400\">SALARY<\/span><\/td>\n<td><span style=\"font-weight: 400\">JOINING_DATE<\/span><\/td>\n<td><span style=\"font-weight: 400\">DEPARTMENT<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">001<\/span><\/td>\n<td><span style=\"font-weight: 400\">NIHARIKA <\/span><\/td>\n<td><span style=\"font-weight: 400\">ARORA<\/span><\/td>\n<td><span style=\"font-weight: 400\">20000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2013-02-25 09:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">HR<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">002<\/span><\/td>\n<td><span style=\"font-weight: 400\">AYUSHI<\/span><\/td>\n<td><span style=\"font-weight: 400\">GURONDIA<\/span><\/td>\n<td><span style=\"font-weight: 400\">5000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2015-02-10 09:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">ADMIN<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">003<\/span><\/td>\n<td><span style=\"font-weight: 400\">PRIYANSHA <\/span><\/td>\n<td><span style=\"font-weight: 400\">CHOUKSEY<\/span><\/td>\n<td><span style=\"font-weight: 400\">25000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2014-05-16 09:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">HR<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">004<\/span><\/td>\n<td><span style=\"font-weight: 400\">APARNA <\/span><\/td>\n<td><span style=\"font-weight: 400\">DESHPANDE<\/span><\/td>\n<td><span style=\"font-weight: 400\">8000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-12-20 09:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">ADMIN<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">005<\/span><\/td>\n<td><span style=\"font-weight: 400\">SHAFALI<\/span><\/td>\n<td><span style=\"font-weight: 400\">JAIN<\/span><\/td>\n<td><span style=\"font-weight: 400\">21000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2015-08-29 09:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">ADMIN<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">006<\/span><\/td>\n<td><span style=\"font-weight: 400\">SUCHITA <\/span><\/td>\n<td><span style=\"font-weight: 400\">JOSHI<\/span><\/td>\n<td><span style=\"font-weight: 400\">20000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2017-02-12 09:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">ACCOUNT<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">007<\/span><\/td>\n<td><span style=\"font-weight: 400\">SHUBHI<\/span><\/td>\n<td><span style=\"font-weight: 400\">MISHRA<\/span><\/td>\n<td><span style=\"font-weight: 400\">15000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2018-03-23 09:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">ADMIN<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">008<\/span><\/td>\n<td><span style=\"font-weight: 400\">DEVYANI <\/span><\/td>\n<td><span style=\"font-weight: 400\">PATIDAR<\/span><\/td>\n<td><span style=\"font-weight: 400\">18000<\/span><\/td>\n<td><span style=\"font-weight: 400\">2014-05-02 09:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">ACCOUNT<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>TABLE- BONUS<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">WORKER_REF_ID<\/span><\/td>\n<td><span style=\"font-weight: 400\">BONUS_DATE<\/span><\/td>\n<td><span style=\"font-weight: 400\">BONUS_AMOUNT<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<td><span style=\"font-weight: 400\">2015-04-20 00:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">5000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<td><span style=\"font-weight: 400\">2015-08-11 00:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">3000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">3<\/span><\/td>\n<td><span style=\"font-weight: 400\">2015-04-20 00:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">4000<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<td><span style=\"font-weight: 400\">2015-04-20 00:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">4500<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<td><span style=\"font-weight: 400\">2015-08-11 00:00:00<\/span><\/td>\n<td><span style=\"font-weight: 400\">3500<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>TABLE- TITLE<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">WORKER_REF_ID<\/span><\/td>\n<td><span style=\"font-weight: 400\">WORKER_TITLE<\/span><\/td>\n<td><span style=\"font-weight: 400\">AFFECTED_FROM<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<td><span style=\"font-weight: 400\">Manager<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-02-20 00:00:00<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<td><span style=\"font-weight: 400\">Executive<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-06-11 00:00:00<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">8<\/span><\/td>\n<td><span style=\"font-weight: 400\">Executive<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-06-11 00:00:00<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">5<\/span><\/td>\n<td><span style=\"font-weight: 400\">Manager<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-06-11 00:00:00<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">4<\/span><\/td>\n<td><span style=\"font-weight: 400\">Asst. Manager<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-06-11 00:00:00<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">7<\/span><\/td>\n<td><span style=\"font-weight: 400\">Executive<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-06-11 00:00:00<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">6<\/span><\/td>\n<td><span style=\"font-weight: 400\">Lead<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-06-11 00:00:00<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">3<\/span><\/td>\n<td><span style=\"font-weight: 400\">Lead<\/span><\/td>\n<td><span style=\"font-weight: 400\">2016-06-11 00:00:00<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>i. Query to create the Database<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE DATABASE ORG;\r\nSHOW DATABASES;\r\nUSE ORG;<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-create-database\/\">Learn more about SQL create Database<\/a><\/strong><\/p>\n<h3>ii. Query to create the Table<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE TABLE Worker (\r\nWORKER_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,\r\nFIRST_NAME CHAR(25),\r\nLAST_NAME CHAR(25),\r\nSALARY INT(15),\r\nJOINING_DATE DATETIME,\r\nDEPARTMENT CHAR(25)\r\n);<\/pre>\n<h3>iii. Query to insert into the Table Worker<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">INSERT INTO Worker\r\n(WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES\r\n(001, \u2018NIHARIKA\u2019, \u2018ARORA\u2019, \u201820000\u2019, \u20182013-02-25 09:00:00\u2019, \u2018HR\u2019)\r\n(002, \u2018AYUSHI\u2019, \u2018GURONDIA\u2019, \u20185000\u2019, \u20182015-02-10 09:00:00\u2019, \u2018ADMIN\u2019)\r\n(003,\u2019 PRIYANSHA, CHOUKSEY\u2019, \u201825000\u2019, \u20182014-05-16 09:00:00\u2019, \u2018HR\u2019)\r\n(004, \u2018APARNA\u2019, \u2019DESHPANDE\u2019, \u20188000\u2019, \u20182016-12-20 09:00:00\u2019, \u2018ADMIN\u2019)\r\n(005, \u2018SHAFALI\u2019, \u2018JAIN\u2019, \u201821000\u2019, \u20182015-08-29 09:00:00\u2019, ADMIN\u2019)\r\n(006, \u2018SUCHITA\u2019, \u2018JOSHI\u2019, \u201820000\u2019, \u20182017-02-12 09:00:00\u2019, \u2018ACCOUNT\u2019)\r\n(007, \u2018SHUBHI\u2019, \u2018MISHRA\u2019, \u201815000\u2019, \u20182018-03-23 09:00:00\u2019, \u2018ADMIN\u2019)\r\n(008, \u2018DEVYANI\u2019, \u2018PATIDAR\u2019, \u201818000\u2019, \u20182014-05-02 09:00:00\u2019, \u2018ACCOUNT\u2019);<\/pre>\n<h3>iv. Query to create table Bonus<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE TABLE Bonus (\r\nWORKER_REF_ID INT,\r\nBONUS_AMOUNT INT(10),\r\nBONUS_DATE DATETIME,\r\nFOREIGN KEY (WORKER_REF_ID)\r\nREFERENCES Worker(WORKER_ID)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ON DELETE CASCADE\r\n);<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/primary-and-foreign-key-in-sql\/\">Let&#8217;s revise the primary and foreign key in SQL<\/a><\/strong><\/p>\n<h3>v. Query to insert into table Bonus<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">INSERT INTO Bonus\r\n(WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES\r\n(001, 5000, '15-04-20'),\r\n(002, 3000, '15-08-11'),\r\n(003, 4000, '15-04-20'),\r\n(001, 4500, '15-04-20'),\r\n(002, 3500, '15-08-11');<\/pre>\n<h3>vi. Query to create table Title<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE TABLE Title (\r\nWORKER_REF_ID INT,\r\nWORKER_TITLE CHAR(25),\r\nAFFECTED_FROM DATETIME,\r\nFOREIGN KEY (WORKER_REF_ID)\r\nREFERENCES Worker(WORKER_ID)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ON DELETE CASCADE\r\n);<\/pre>\n<h3>vii. Query to insert into table Title<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">INSERT INTO Title\r\n(WORKER_REF_ID, WORKER_TITLE, AFFECTED_FROM) VALUES\r\n(001, 'Manager', '2016-02-20 00:00:00'),\r\n(002, 'Executive', '2016-06-11 00:00:00'),\r\n(008, 'Executive', '2016-06-11 00:00:00'),\r\n(005, 'Manager', '2016-06-11 00:00:00'),\r\n(004, 'Asst. Manager', '2016-06-11 00:00:00'),\r\n(007, 'Executive', '2016-06-11 00:00:00'),\r\n(006, 'Lead', '2016-06-11 00:00:00'),\r\n(003, 'Lead', '2016-06-11 00:00:00');<\/pre>\n<p>In this way, you can create and insert values into the table. So, let&#8217;s start SQL Query Interview Questions and Answers.<\/p>\n<p><strong>Recommended Reading &#8211; <a href=\"https:\/\/data-flair.training\/blogs\/sql-subquery\/\">SQL Subquery<\/a><\/strong><\/p>\n<h2>3. 30 Complex SQL Queries Interview Questions and Answers<\/h2>\n<p>Now you know how to create table and insert values in it through SQL Query.\u00a0 So, let&#8217;s practice the SQL Query through the best and important SQL Query Interview Questions.<\/p>\n<p><strong>Q.1 Write an SQL query for fetching \u201cFIRST_NAME\u201d from the WORKER table using &lt;WORKER_NAME&gt; as alias.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that you can use is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select FIRST_NAME AS WORKER_NAME from Worker;<\/pre>\n<p><strong>Q.2 What is an SQL Query for fetching the \u201cFIRST_NAME\u201d from WORKER table in upper case?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that you can use is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select upper(FIRST_NAME) from Worker;<\/pre>\n<p><strong>Q.3 What is an SQL query for fetching the unique values of the column DEPARTMENT from the WORKER table?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that you cam use is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select distinct DEPARTMENT from Worker;<\/pre>\n<p><strong>Q.4 Write an SQL query for printing the first three characters of the column FIRST_NAME.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select substring(FIRST_NAME,1,3) from Worker;<\/pre>\n<p><strong>Q.5 What is an SQL query for finding the position of the alphabet (\u2018A\u2019) in the FIRST_NAME column of Ayushi.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select INSTR(FIRST_NAME, BINARY'a') from Worker where FIRST_NAME = 'Ayushi';<\/pre>\n<p><strong>Q.6 What is an SQL Query for printing the FIRST_NAME from Worker Table after the removal of white spaces from right side.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select RTRIM(FIRST_NAME) from Worker;<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-query-optimization\/\">You must read about SQL Query Optimization tools<\/a><\/strong><\/p>\n<p><strong>Q<\/strong><strong>.7 Write an SQL Query for printing the DEPARTMENT from Worker Table after the removal of white spaces from the left side.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that you can use is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select LTRIM(DEPARTMENT) from Worker;<\/pre>\n<p><strong>Q.8 What is an SQL query for fetching the unique values from the DEPARTMENT column and thus printing is the length?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that you can use is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select distinct length(DEPARTMENT) from Worker;<\/pre>\n<p><strong>Q.9 Write an SQL query for printing the FIRST_NAME after replacing \u2018A\u2019 with \u2018a\u2019.<\/strong><\/p>\n<p><span style=\"font-weight: 400\">The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select REPLACE(FIRST_NAME,'a','A') from Worker;<\/pre>\n<p><strong>Q.10 What is an SQL query for printing the FIRST_NAME and LAST_NAME into a column named COMPLETE_NAME? (A space char should be used)<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select CONCAT(FIRST_NAME, ' ', LAST_NAME) AS 'COMPLETE_NAME' from Worker;<\/pre>\n<p><strong>Q.11 What is an SQL query for printing all details of the worker table which ordered by FIRST_NAME ascending?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker order by FIRST_NAME asc;<\/pre>\n<p><strong>Q.12 Write an SQL query for printing the all details of the worker table which ordered by FIRST_NAME ascending and the DEPARTMENT in descending <\/strong><\/p>\n<p><span style=\"font-weight: 400\">The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker order by FIRST_NAME asc,DEPARTMENT desc<\/pre>\n<p><span style=\"font-weight: 400\"><strong>Q.13 What is an SQL query to print the details of the workers \u2018NIHARIKA\u2019 and \u2018PRIYANSHA\u2019.<\/strong> <\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker where FIRST_NAME in ('NIHARIKA','PRIYANSHA');<\/pre>\n<p><strong>Q.14 What is an SQL query printing all details of workers excluding the first names of \u2018NIHARIKA\u2019 and \u2018PRIYANSHA\u2019<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker where FIRST_NAME not in ('NIHARIKA','PRYANSHA');<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/dynamic-sql\/\">Do you know about dynamic SQL tutorial?<\/a><\/strong><\/p>\n<p><strong>Q.15 Write an SQL query for printing the details of DEPARTMENT name as \u201cAdmin\u201d.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker where DEPARTMENT like 'Admin%';<\/pre>\n<p><strong>Q.16\u00a0 What is an SQL query for printing the details of workers whose FIRST_NAME Contains \u2018A\u2019?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker where FIRST_NAME like '%a%';<\/pre>\n<p><strong>Q.17 What is an SQL Query for printing the FIRST_NAME of workers whose name ends with \u2018A\u2019?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.\u00a0<\/strong>The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker where FIRST_NAME like '%a';<\/pre>\n<p><strong>Q.18 What is an SQL Query for printing the details of the workers whose FIRST_NAME ends with \u2018H\u2019 and contains six alphabets?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker where FIRST_NAME like '_____h';<\/pre>\n<p><strong>Q.19 Write an SQL Query for printing the details of workers whose SALARY lies between 10000 and 20000.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker where SALARY between 10000 and 20000;<\/pre>\n<p><strong>Q.20 Write an SQL Query for printing the details of workers who joined inFeb\u20192014<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from Worker where year(JOINING_DATE) = 2014 and month(JOINING_DATE) = 2;<\/pre>\n<p><strong>Q.21 Write an SQL Query for fetching the count of workers in DEOARTMENT with \u2018Admin\u2019.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong>\u00a0The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT COUNT(*) FROM worker WHERE DEPARTMENT = 'Admin';<\/pre>\n<p><strong>Q.22 Write an SQL Query for fetching the details of workers with Salaries &gt;= 5000 and &lt;= 10000.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT CONCAT(FIRST_NAME, ' ', LAST_NAME) As Worker_Name, Salary\r\nFROM worker\r\nWHERE WORKER_ID IN\r\n(SELECT WORKER_ID FROM worker\r\nWHERE Salary BETWEEN 5000 AND 10000);<\/pre>\n<p><strong>Q.23 What is an SQL Query for fetching the no. of workers in each department in descending order?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DEPARTMENT, count(WORKER_ID) No_Of_Workers\r\nFROM worker\r\nGROUP BY DEPARTMENT\r\nORDER BY No_Of_Workers DESC;<\/pre>\n<p><strong>Q.24 What is an SQL Query for printing the details of workers who are also managers?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT DISTINCT W.FIRST_NAME, T.WORKER_TITLE\r\nFROM Worker W\r\nINNER JOIN Title T\r\nON W.WORKER_ID = T.WORKER_REF_ID\r\nAND T.WORKER_TITLE in ('Manager');<\/pre>\n<p><strong>Q.25 Write an SQL Query for fetching the details of duplicate records in some fields.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT WORKER_TITLE, AFFECTED_FROM, COUNT(*)\r\nFROM Title\r\nGROUP BY WORKER_TITLE, AFFECTED_FROM\r\nHAVING COUNT(*) &gt; 1;<\/pre>\n<p><strong>Q.26 What is an SQL Query for only showing odd rows?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM Worker WHERE MOD (WORKER_ID, 2) &lt;&gt; 0;<\/pre>\n<p><strong>Q.27 What is an SQL Query for only showing even rows?<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM Worker WHERE MOD (WORKER_ID, 2) = 0;<\/pre>\n<p><strong>Q.28 Write an SQL Query for cloning a new table from another table.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The general query that can be used to clone a table with data is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * INTO WorkerClone FROM Worker;<\/pre>\n<p><span style=\"font-weight: 400\">The general way that can be used to clone a table without information is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * INTO WorkerClone FROM Worker WHERE 1 = 0;<\/pre>\n<p><strong>Q.29 Write an SQL Query for fetching the intersecting details of two tables.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">(SELECT * FROM Worker)\r\nINTERSECT\r\n(SELECT * FROM WorkerClone);<\/pre>\n<p><strong>Q.30 What is an SQL Query for showing the details of one table that another doesn\u2019t have.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> The query that can be used is:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM Worker\r\nMINUS\r\nSELECT * FROM Title;<\/pre>\n<p>So, this was all in SQL Query Interview Questions and Answers. Hope you liked the explanation.<\/p>\n<h2><span style=\"font-weight: 400\">4. Summary &#8211; SQL Queries<\/span><\/h2>\n<p>Hence, you have completed the blog of <strong><a href=\"http:\/\/sql.org\/\">SQL<\/a><\/strong> Query Interview Questions. In this, you discussed SQL interview questions based on complex queries. Along with this, we saw how can you create a table in SQL and add values to it. Moreover, you learned all the type of SQL Queries which could be asked in any technical SQL interview.<\/p>\n<p>Still, if you have any doubt in SQL Query Interview Questions, you can freely ask in the comment tab.<\/p>\n<p><strong>You must check &#8211; <a href=\"https:\/\/data-flair.training\/blogs\/sql-interview-questions-and-answers\/\">What are the frequently asked SQL Interview Questions<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Most Asked SQL Query Interview Questions Earlier we have discussed the different types of SQL questions asked in the interview. Today, we will focus on a particular type and that is SQL Query&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":46007,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[17984,17985,13483,17981,17986,17982,17983,17979,17980,17987],"class_list":["post-45966","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-complex-sql-interview-questions","tag-important-sql-queries-asked-in-interview","tag-sql-interview-questions","tag-sql-practice-questions","tag-sql-queries","tag-sql-queries-for-interview","tag-sql-queries-practice","tag-sql-query-interview-questions","tag-sql-query-questions","tag-sql-scenario-based-questions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Query Interview Questions - Practice All Types of SQL Queries - DataFlair<\/title>\n<meta name=\"description\" content=\"Some of the mostly asked SQL Query Interview Questions with their Answer.This contains all types of SQL queries that can practice online,test your knowledge\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Query Interview Questions - Practice All Types of SQL Queries - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Some of the mostly asked SQL Query Interview Questions with their Answer.This contains all types of SQL queries that can practice online,test your knowledge\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-19T11:35:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-19T11:37:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Query Interview Questions - Practice All Types of SQL Queries - DataFlair","description":"Some of the mostly asked SQL Query Interview Questions with their Answer.This contains all types of SQL queries that can practice online,test your knowledge","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/","og_locale":"en_US","og_type":"article","og_title":"SQL Query Interview Questions - Practice All Types of SQL Queries - DataFlair","og_description":"Some of the mostly asked SQL Query Interview Questions with their Answer.This contains all types of SQL queries that can practice online,test your knowledge","og_url":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-12-19T11:35:39+00:00","article_modified_time":"2018-12-19T11:37:59+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SQL Query Interview Questions &#8211; Practice All Types of SQL Queries","datePublished":"2018-12-19T11:35:39+00:00","dateModified":"2018-12-19T11:37:59+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/"},"wordCount":1309,"commentCount":10,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg","keywords":["complex sql interview questions","important sql queries asked in interview","SQL Interview Questions","sql practice questions","SQL Queries","sql queries for interview","sql queries practice","sql query interview questions","sql query questions","SQL Scenario based questions"],"articleSection":["SQL Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/","url":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/","name":"SQL Query Interview Questions - Practice All Types of SQL Queries - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg","datePublished":"2018-12-19T11:35:39+00:00","dateModified":"2018-12-19T11:37:59+00:00","description":"Some of the mostly asked SQL Query Interview Questions with their Answer.This contains all types of SQL queries that can practice online,test your knowledge","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Query-Interview-Questions.jpg","width":1200,"height":628,"caption":"SQL Query Interview Questions - Practice All Type of SQL Queries"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sql-query-interview-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SQL Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sql\/"},{"@type":"ListItem","position":3,"name":"SQL Query Interview Questions &#8211; Practice All Types of SQL Queries"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/45966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=45966"}],"version-history":[{"count":6,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/45966\/revisions"}],"predecessor-version":[{"id":46010,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/45966\/revisions\/46010"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/46007"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=45966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=45966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=45966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}