Time is a vital resource that each business treasures and attempts to transform in a advantage. In choosing document management software, pay attention to a clutterless and user-friendly interface that empowers consumers. DocHub delivers cutting-edge tools to maximize your file management and transforms your PDF file editing into a matter of a single click. Remove Comments to the Interview Schedule with DocHub in order to save a lot of efforts and enhance your productiveness.
Make PDF file editing an simple and intuitive process that saves you plenty of precious time. Effortlessly modify your documents and deliver them for signing without turning to third-party solutions. Focus on pertinent tasks and boost your file management with DocHub starting today.
hey guys welcome back to the channel so this channel everyday data science is all about trying to learn the various concepts involved in data science by practicing a lot of questions in this video i am going to solve this question on lead code called number of comments per post and try to walk you through how we can develop queries in such problems this question has been asked in facebook a couple of times in the past couple of years okay so lets read the question and see what its asking we are given a table called submissions with two columns sub id and parent id with the data type being integer there is no primary key for this table it may have duplicate rows okay each row can be a post or comment on the post okay parent id is null for post so basically if a row has null in the parent id column then it is a post otherwise it is a comment parent id for comments is sub id for another post in the table yep okay we are asked to write a sql query to find the number of comments per post