Hi Thoufiq. The way you explain these queries can make even a child understand these complex codes better. You are doing amazing work. Please continue to solve more complex problems on Stratascratch
@techTFQ
2 жыл бұрын
Thank you Gautham :) Glad you liked it
@janntulfahim9009
12 күн бұрын
I really appreciate the methodology of breaking down problems into different sections and solving them one by one. At first glance, the code seemed complicated, but this approach made it much easier to understand. Thank you!
@fathimafarahna2633
2 жыл бұрын
The love & appreciation you get from subs and ppl is an indication you are doing something right.. Keep it up🤗 God bless you. Masha Allaah
@techTFQ
2 жыл бұрын
Thank you so much 😀
@ashutoshbafna6617
2 жыл бұрын
Superb . Please solve more queries , difficult queries like 2 seats in last part . I will definitely explore platform you have recommended . Thank you very much , it's really helpful .
@techTFQ
2 жыл бұрын
Your welcome Ashutosh 🙏🏼 Glad you liked it
@pveeranjireddy8959
2 жыл бұрын
You are doing videos fast,but for us taking time keep those concepts into brain...you are lessons great and so logical. 👍😀😀
@techTFQ
2 жыл бұрын
I want to make it slow buddy but the videos are already so long , I wish to make it a little short by talking a little fast 😁😊 But thank you so much for still watching and your continuous feedback 🙏🏼
@markojelic5670
2 жыл бұрын
What a great breakdown! I think a kindergartener would be able to solve this problem after watching your explanation video. Keep at it friend!
@Datapassenger_prashant
2 жыл бұрын
Thank you for this techTFQ as I really needed to practice and bounce back as I just failed the interview, even when I was good in SQL sometime back.
@techTFQ
2 жыл бұрын
Glad it helped and good luck Prashant for the future interviews!
@myangle6417
2 жыл бұрын
you are my sql guru, learning a lot from you thanks for your lessions.
@techTFQ
2 жыл бұрын
Glad to hear that :)
@ejbjms
2 жыл бұрын
You are solving some real good SQL queries and not simple and stupid ones. Great job!
@techTFQ
2 жыл бұрын
Glad you like them!
@vishalkarur5366
2 жыл бұрын
Wow I was just about to make a LinkedIn post asking if any one could suggest resource to revise and practice SQL. ❤️❤️
@techTFQ
2 жыл бұрын
Glad this helped you Vishal :)
@sirvachjumani7215
2 жыл бұрын
Real amazing content to learn SQL quires for an interview can you please solve more problems on Stratascratch for SQL and Python.
@elmira363
2 жыл бұрын
Thank you a lot dear! It's my first try in sql and it was with your video 👏 amazing job All the best for you God bless you
@techTFQ
2 жыл бұрын
Thank you 🙏🏼 Glad you found it helpful
@arundhatisarkar8250
2 жыл бұрын
Love the content Thoufiq. Could you add practice problems in Python/R and BI tools as well? Would help loads!
@techTFQ
2 жыл бұрын
Thank you Arundhati :) and sure will consider the request
@pranavkmishra
2 жыл бұрын
This was really very helpful Toufiq
@techTFQ
2 жыл бұрын
I am glad to hear that pranav
@uzairchaudhary6888
Жыл бұрын
Hey I've solved the last question like this with cte as (select t.seat_number,t.is_available,s.seat_left, lag(t.is_available)over() as lg from theater_availability t join theater_seatmap s on s.seat_number = t.seat_number), cte2 as (select seat_number, is_available,lg, seat_left from cte where is_available = lg and is_available FALSE and lg FALSE and seat_left is not null) select seat_left as seat1, seat_number as seat2 from cte2
@manojgullapalli4302
2 жыл бұрын
Dear Thoufiq, your explanation is awesome, can you place many scenarios of complex queries generally we face in real time
@Mamuchonga01
2 жыл бұрын
I am learning SQL,you are the best.
@techTFQ
2 жыл бұрын
Glad to hear that!
@user-nh8bg5po6v
Жыл бұрын
From your approaches to your explanations, everything is amazing! Hope you will continue making more problem solving videos like this :)
@navpostmalone9008
2 жыл бұрын
Hi Tfq great content, how are you able to solve complex queries with such ease ? any tips or suggestions?
@techTFQ
2 жыл бұрын
It's not always so easy. But the only way to get better is solving more queries. More experience you gain, better you get
@tamil1health979
2 жыл бұрын
True
@jolin271
2 жыл бұрын
Great work. 👏👏 Please continue the SQL series
@techTFQ
2 жыл бұрын
Thank you :)
@anjuachuthan5239
2 жыл бұрын
Very useful video Thoufiq.. keep posting more
@techTFQ
2 жыл бұрын
Thank you Shriya, I will
@passions9730
2 жыл бұрын
Loved the content ..thank you thoufiq bro..keep doing awesome videos..we always support you..😊👍
@techTFQ
2 жыл бұрын
Thank you so much buddy 🙏🏼
@rumeysaeren7030
2 жыл бұрын
It's is very useful video for me. Please make more videos on stratascratch. You are explanations are perfect
@techTFQ
2 жыл бұрын
Thank you :)
@abdelkaderkaouane1944
2 жыл бұрын
Amazing as all your videos. Thank you thank you thank you. I learn a lot from you.
@techTFQ
2 жыл бұрын
Really glad to hear that ☺️☺️
@satyapanthamsrinivas
2 жыл бұрын
Thank you so much for your effort Tfq, please do continue doing more SQL videos.
@techTFQ
2 жыл бұрын
Glad you liked it and sure will do
@hadiuzzaman
2 жыл бұрын
Excellent content, Vai. Keep posting such great videos.
@techTFQ
2 жыл бұрын
Many many thanks Hadi
@mohithnarravula7226
2 жыл бұрын
I love this video. I get to know how to break the problem and slove. Make more videos like this is helping a lot.😍😍
@techTFQ
2 жыл бұрын
Thank you Mohith :)
@asmaaabdulhamid2292
2 жыл бұрын
Tawfiq , thanks a lot for this useful video, a lot of this content, please
@techTFQ
2 жыл бұрын
Thank you Asmaa and noted
@paub8302
2 жыл бұрын
Great content and thank you so much. I learned a lot. Hopefully you will continue uploading and sharing more complex queries. More power!
@techTFQ
2 жыл бұрын
Thank you Pau :) Glad you liked it
@sudhashahi7263
2 жыл бұрын
I wish if you could be my mentor. All of your videos are great and simple to grasp the concept. Thank you!
@techTFQ
2 жыл бұрын
Thank you for your kind words Sudha :)
@suvch5842
2 жыл бұрын
@@techTFQ sir do you have any course for SQL or data analytics or any website to like connect with you
@techTFQ
2 жыл бұрын
Have not made any course yet .. You can reach me on LinkedIn . You can find the link in my channel
@suvch5842
2 жыл бұрын
@@techTFQ if possible please let me know sir
@suvch5842
2 жыл бұрын
@@techTFQ sure sir thanks for letting me know
@vishalnasre1251
2 жыл бұрын
Thanks TFQ, please upload next part also, thanks again.
@techTFQ
2 жыл бұрын
Glad you liked it and will do
@sumitrauniyar7347
Жыл бұрын
Alternate : ----------------- with cte1 as ( select user_id,date(timestamp) as date , TIMESTAMPDIFF(SECOND, max(case when action = 'page_load' then timestamp else null end), min(case when action = 'page_exit' then timestamp else null end)) as diff from facebook_web_log where action in ("page_load","page_exit") group by 1,2 ) select user_id , avg(diff) as avg from cte1 where diff is not null group by user_id
@AK-wo7jz
2 жыл бұрын
Thanks for educating us...Great way of explanation...
@techTFQ
2 жыл бұрын
Glad you liked it
@jananishanmugam8204
8 ай бұрын
Hi Thoufiq, I have a doubt, in the second question, why do you do union, cant we just consider center_seat and right_seat or center_seat and left_seat. As the output anyways should be paired! Please let me know
@shivsharma9153
2 жыл бұрын
Thank youuuu soooooooooo much for these videos..sooooooooo helpful
@techTFQ
2 жыл бұрын
You are so welcome Shiv!
@prajwallikhithapudi2748
2 жыл бұрын
Great Content as always 🎉 ! Would love to see more from stratascratch
@techTFQ
2 жыл бұрын
Thank you and will do :)
@cute7606
2 жыл бұрын
Привет, спасибо тебе! На Российском KZitem информации нет по этой теме. Сложно понимать твой акцент, но я стараюсь 😬
@agrim8863
2 жыл бұрын
Hii, thoufiq thank for awesome video great content. I would request you to please take some advance classes on sql like one you took last month (sql for beginners).
@techTFQ
2 жыл бұрын
Hi Agrim, I am planning to start an SQL query writing session end of this month. Plan to solve some basic, intermediate and complex queries live .. I’ll be announcing it in few days
@maruthisinger5106
2 жыл бұрын
Great work! Appreciated your efforts.
@techTFQ
2 жыл бұрын
Thank you 🙏🏼
@abinashdas12
2 жыл бұрын
Highly appreciating one ...please keep posting such content
@techTFQ
2 жыл бұрын
Thank you Das and will do
@msraju449peace
7 ай бұрын
Thank you very much, Sir, I love your lectures
@priyadharshini-oe7zf
2 жыл бұрын
Thank you for the useful videos. Could you please do a video with the new inbuild functions in the SQL server newer versions? It will be really helpful
@techTFQ
2 жыл бұрын
Glad you liked it and noted on the request, will consider doing it
@aashishraina2831
2 жыл бұрын
Thanks for the explanation.
@techTFQ
2 жыл бұрын
Your welcome buddy
@enjoycook7099
Жыл бұрын
Hi Bro , your videos are amazing . Can you please make a video to understand logic need to be used to write SQL queries
@shivammishra-mk9jp
2 жыл бұрын
Your video always worth watch sir.....👍
@techTFQ
2 жыл бұрын
Thanks a ton Shivam
@roysaradhy8826
2 жыл бұрын
Awesome work, it's worth sparing some time in learning. Keep up the great work.
@techTFQ
2 жыл бұрын
Thank you Roy
@chaitanyagupta4117
2 жыл бұрын
Thanks Taufiq, I was looking for good resource to practice. Could you please make a video on COALESCE function too?
@ritikajaiswal3824
2 жыл бұрын
It returns only non null values
@techTFQ
2 жыл бұрын
ill explain Coalesce in a future video
@mohammedabdeen6329
2 жыл бұрын
You are doing amazing work here than you
@techTFQ
2 жыл бұрын
Glad you liked it
@iammip
2 жыл бұрын
Tfq sir all the sql related topics available on ir channel? If some looking to start from scratch?
@techTFQ
2 жыл бұрын
I plan to make a complete tutorial series for beginners in my channel soon.. where I will cover all topics from scratch
@SudhirKumar-rl4wt
2 жыл бұрын
Thanks for the tutorial
@techTFQ
2 жыл бұрын
You are welcome :)
@hiteshagnihotri5590
Жыл бұрын
Your course on SQL is just awesome. Just one question Which is better platform to practice sql stratascratch,hackerrank or leetcode?
@mhapich
Жыл бұрын
And there’s datalemur!
@aesthetic_pens
2 жыл бұрын
Hi Can you please provide the solution for Gender With Generous Reviews, I think I am stuck somewhere and not able to find out, thanks for your videos they always help me a lot, keep up the good work
@beyond_success
2 жыл бұрын
Your tutorials helping a lot, please explain pivot in mysql
@techTFQ
2 жыл бұрын
MySQL does not have PIVOT but we can do same thing in mysql using CASE statement. I have explained it in my leetcode video haha same question multiple times so same reply Ahmed :)
@beyond_success
2 жыл бұрын
Mashallah, thanks for the reply sir
@juhairahamed5342
2 жыл бұрын
Good explanation .
@techTFQ
2 жыл бұрын
Thank you :)
@murtazajabalpurwala8124
Жыл бұрын
thank you for he detailed explaination. Amazing
@djjiang3718
2 жыл бұрын
Love stratascratch as well! I am an Long term user
@sudhanshugupta7178
2 жыл бұрын
Your videos are informational … do you take online teaching sessions … ?
@techTFQ
2 жыл бұрын
Thank you :) and yes i do on lighthall.co
@pveeranjireddy8959
2 жыл бұрын
Thank you Thoufiq ..
@techTFQ
2 жыл бұрын
Your welcome buddy
@almassheraz9412
2 жыл бұрын
Masha Allah..keep up the good work..
@techTFQ
2 жыл бұрын
Thank you bro ☺️
@marsrover2754
2 жыл бұрын
Do you mind rearraging your SQL tutorial series in sequence and which one to follow first.
@mirageman2
2 жыл бұрын
Hi, great video, thanks a lot. I am wondering how you would write the query if a user could login on one day and exit the other day (say he logs in on saturday at 11 p.m. and leaves the site at 1 a.m. the other day).
@parthsurati7436
Жыл бұрын
Classic please come up with more questions and answers query session
@hemanthnaidu6178
2 жыл бұрын
Hi Bro... I have a doubt please clarify it , you have wrote the */ at the beginning and ending of the query to not to excute first query, what symbols are used in MS SQL to hide the one query where we have multiple queries as you done in the video. Thank you
@techTFQ
2 жыл бұрын
/* this is comment */ the above is the way to comment a piece of query or code. And this will work is MSSQL, Oracle, PostgreSQL, MySQL etc.
@hemanthnaidu6178
2 жыл бұрын
@@techTFQ thank you bro
@bembambimbombum
Жыл бұрын
Man, you're so goooood! Thank you!
@guntnaveen1568
2 жыл бұрын
Excellent i want to join in SQL class. Can you send link
@techTFQ
2 жыл бұрын
You can find it in my website with all the other details.. techtfq.com
@shubhangshukla3179
2 жыл бұрын
sir how you shift the written sub-query to right to make it look clean. what is the shortcut key?
@techTFQ
2 жыл бұрын
using TAB key bro
@shubhangshukla3179
2 жыл бұрын
@@techTFQ thankyou sir 🙏
@hemaraj1646
Жыл бұрын
Hi Thoufiq, I like to practice medium to high complex queries for clearing interviews. Which Plan is ideal for me at the moment. Also like to know which subscription is better. Leetcode or StrataScratch? Please suggest.
@ss-vx9dk
2 жыл бұрын
I sir tq for your explanation it's great feeling
@techTFQ
2 жыл бұрын
Thank you 🙏🏼
@amardeepkumar1267
2 жыл бұрын
Link in the description is not working for other playlist., Sir! Plz check
@techTFQ
2 жыл бұрын
I will need to update it bro.
@oscararmandocisnerosruvalc8503
2 жыл бұрын
can you address the cheapest airline connection, please !!!. I thought that one is really hard
@techTFQ
2 жыл бұрын
is it a question from StrataScratch?
@oscararmandocisnerosruvalc8503
2 жыл бұрын
@@techTFQ yes, there are a lot of good and hard questions :)
@nayeem3905
2 жыл бұрын
Any recommendations for people that want to use ms sql server? Thank you
@ajithshenoy5566
2 жыл бұрын
Hey @techTFQ Thoufiq can you pelase create a video on case statements in sql and their advanced cases as well? thanks
@techTFQ
2 жыл бұрын
Noted Ajith, will do
@langtonkadzere5737
2 жыл бұрын
Hi techTFQ could you please do a video on TRIGGERS....? Great and clear tutorials
@techTFQ
2 жыл бұрын
Thank you :) and sure will do
@sanjeetlal1873
2 жыл бұрын
Top content as always 👌
@techTFQ
2 жыл бұрын
Glad you liked it Sanjeet!
@CaribouDataScience
2 жыл бұрын
What would happen if you did something like : SELECT use_id,max(timestamp) - min(timestamp group by us_id?
@JMCodd1
2 жыл бұрын
I believe that would give you the length of time between the first record and the last record, grouped by user_id.
@abhilashpatil6778
2 жыл бұрын
How to insert the column from one table1 to another table2 but in table 2 we have many columns and in table 1we have one column.
@sabitapatnaik9855
2 жыл бұрын
Hello Thoufiq please start new batches for SQL🙂
@techTFQ
2 жыл бұрын
Just announced the class yesterday. You can view the contents and register for the class from my website. Link below: techtfq.com/my-sql-course
@pveeranjireddy8959
2 жыл бұрын
I will join Aug 03 live classes by paying Thoufiq .
@techTFQ
2 жыл бұрын
Will be glad to have you Pveeranji
@rameshbabu5372
2 жыл бұрын
Fantastic..can you please work on one session for only on date functions.
@techTFQ
2 жыл бұрын
Noted Ramesh , will do it
@mkga6274
Жыл бұрын
Thank you kind sir.
@zishanafzal6671
2 жыл бұрын
Great explanation👍
@pratyakshaparashar5306
2 жыл бұрын
There are 8 IPL team. write a sql query that no team plays with other team more than once...... How to write this query ?
@techTFQ
2 жыл бұрын
ill try to include this query as part of my sql query training class starting next week.
@techTFQ
2 жыл бұрын
I just posted a video yesterday where I have solved this query. perhaps you can check it. link below: kzitem.info/news/bejne/wntsmGecn2mrnoI
@pratyakshaparashar5306
2 жыл бұрын
@@techTFQ Thanks a lot.
@mohithkethireddi
2 жыл бұрын
hey @tfq does these type of complex queries will be asked in fresher data analyst interviews??
@techTFQ
2 жыл бұрын
Not really.. the questions I solved in these videos should not be asked for freshers ..
@HAMZA-he9nd
2 жыл бұрын
Please make more videos
@techTFQ
2 жыл бұрын
Noted Hamza
@3danim8r1
2 жыл бұрын
Great Content
@techTFQ
2 жыл бұрын
Thank you :)
@movingcloud5253
2 жыл бұрын
Are there any classes
@techTFQ
2 жыл бұрын
will come up soon. ill announce coming week
@shwetapatil6804
2 жыл бұрын
How much the subscription costs
@techTFQ
2 жыл бұрын
You can check it in their website.. But you can also use it for free .. with free account I just get access to few questions I believe
@shashankemani1609
2 жыл бұрын
superb!
@techTFQ
2 жыл бұрын
Thank you 🙏🏼
@mohajanpalash
2 жыл бұрын
just awesome
@techTFQ
2 жыл бұрын
Thank you :)
@monishbabu5065
2 жыл бұрын
More more more more more more more videos pls
@techTFQ
2 жыл бұрын
Noted Monish :)
@lakshminarayana3168
10 ай бұрын
hi , do you have live classes on sql
@techTFQ
9 ай бұрын
Probably in Jan. Ill announce it on LinkedIn
@sekarjntu
2 жыл бұрын
could u share similar site for oracle
@techTFQ
2 жыл бұрын
Ill need to find it bro
@Arunkumar-nb3vx
2 жыл бұрын
You are awesome
@techTFQ
2 жыл бұрын
Thank you Arun :)
@bhababajracharya7401
2 жыл бұрын
Can we check answers without taking a subscription?
@techTFQ
2 жыл бұрын
yes you can
@bhababajracharya7401
2 жыл бұрын
@@techTFQ How to?
@techTFQ
2 жыл бұрын
There are some free questions which you can solve and see answers I’ve shown the answers section in video
@shailendrakumar08
2 жыл бұрын
Amazing!!!
@sandeepkumarsingh7981
2 жыл бұрын
Hey Thoufiq, How can i connect with you ?
@techTFQ
2 жыл бұрын
You can email me at techtfq@gmail.com
@sahilsinghthakur
2 жыл бұрын
Waoooo 🔥❤️
@techTFQ
2 жыл бұрын
Thank you Sahil :)
@praneethveeramachaneni6672
Жыл бұрын
I am getting session time in hours.... someone help me????? with page_load as(SELECT user_id,DATE(timestamp) as load_Date, max(DATE_FORMAT(timestamp,'%T')) as load_time from facebook_web_log where action='page_load' group by user_id,load_Date order by user_id), page_exit as(SELECT user_id,DATE(timestamp) as exit_Date, min(DATE_FORMAT(timestamp,'%H:%i:%s')) as exit_time from facebook_web_log where action='page_exit' group by user_id,exit_Date order by user_id) select pl.user_id, avg(exit_time-load_time) as sesion_time from page_load pl join page_exit pe on pl.load_date=pe.exit_date and pl.user_id=pe.user_id and exit_time>load_time group by user_id;
@srinivasg1331
2 жыл бұрын
జై శ్రీకృష్ణ
@Datapassenger_prashant
2 жыл бұрын
Hi, Did any one tried using MYSQL? as I used the correct query but getting wrong result for user ID = 0 With Data As ( Select PL.user_id, Date(PL.timestamp) as "Date", max(Date_Format(PL.timestamp, "%T")) as 'Load_Time', min(Date_Format(PE.timestamp, "%T")) as 'Exit_Time' from facebook_web_log PL Join facebook_web_log PE on PL.user_id = PE.User_id and Date(PL.timestamp) = Date(PE.timestamp) and Date_Format(PE.timestamp, "%T") > Date_Format(PL.timestamp, "%T") where PL.action = 'page_load' and PE.action = 'page_exit' Group by PL.user_id, Date(PL.timestamp) ) Select user_id, Avg(TIMEDIFF(Exit_Time, Load_Time)) as Session from Data Group by user_id;
@Datapassenger_prashant
2 жыл бұрын
just correct the query using : SEC_TO_TIME(AVG(TIME_TO_SEC(TIMEDIFF(Exit_Time, Load_Time)))) as Avg_Session
Пікірлер: 190