select *, dense_rank () over (order by amount desc) as dn_rnk, rank () over (order by amount desc) as rnk, row_number () over (order by amount desc) as row_number from orders order by amount desc last question answer
How can you join two tables if the columns are not common, table joined based on primary key and foreign key concept, with due respect but what the interviewer mentioned the query at time of the video 21:32 i.e. not correct, clearly "Bretty Doe" has never ordered mousepad ,his customer id is 5 , pls someone correct me if I am wrong ,right query will be below SELECT c.first_name, c.last_name, od.item, od.amount, sh.status from Customers c left join Orders od on c.customer_id=od.customer_id left join Shippings sh on c.customer_id=sh.customer where c.age > 25;
akshay @ I have sent message in email i think you didnt see that message even i am giving the interveiw i have 3 years experience as data engineer . your vids helps to lot great
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
helpful
select
*,
dense_rank () over (order by amount desc) as dn_rnk,
rank () over (order by amount desc) as rnk,
row_number () over (order by amount desc) as row_number
from orders
order by amount desc
last question answer
in last question you should have taken order by clause then how will you find the max number windows function mostly use in order by clause
How can you join two tables if the columns are not common, table joined based on primary key and foreign key concept, with due respect but what the interviewer mentioned the query at time of the video 21:32 i.e. not correct, clearly "Bretty Doe" has never ordered mousepad ,his customer id is 5 , pls someone correct me if I am wrong ,right query will be below SELECT c.first_name, c.last_name, od.item, od.amount, sh.status from Customers c left join Orders od on c.customer_id=od.customer_id
left join Shippings sh
on c.customer_id=sh.customer
where c.age > 25;
What was the pay for this role? How much they were offering
The interviewer was even more confused. 🤣🤣 How can customer_id and shipping_id be used to join two tables?.
🤪
Upload tableau developer videos
other question were easy but frist question did not understand actully what they wanted
How did you got the interview call for Tech M...??? Please help
Please reply!!
What was interview feedback
shortlisted for next round
Why would any data engineer become a data analyst
It’s a roadmap
Data analyst to Data engineer
akshay @ I have sent message in email i think you didnt see that message even i am giving the interveiw i have 3 years experience as data engineer . your vids helps to lot great
Sorry brother, I will check your email , please help me with your subject line or something
Interviewers r idiots thy ask irrelvnt skills which r not mentioned in cv 😂😂😂