Search & Filtering
A C++ program to print the members of a structure using dot operators
Get all the esport videos that crossed one lakh views and were released between 2018 and 2020.
Note:
- Consider the videos that have "esport" in theirname as gaming videos.
- Sort the output in the descending order ofno_of_viewsandpublished_datetime
Expected Output Format
name published_datetime no_of_views
this format write code please help............!!!!!!!
Write a C++ program to count the words and characters in given text using virtual function.
Write a java program to find the sum of all even numbers between 1 to n - using while loop
Create a file named “Circle.txt” and write the following data:
Circle 1, 5
Circle 2,10
Circle 3,4
Each Line has a Circle Name(Circle 1 as in example in 1st line above) and its radius separated by a comma. You have to calculate the Area of
each circle using (pi*r*r) and write it at the end of every line. (5+ 10)
e.g.
Circle 1 , 5, 78.5
Circle 2, 10, 314
Circle 3, 4, 50.24
Objective:
Design a class called NumDays. The class’s purpose is to store a value that represents a number
of work hours and convert it to a number of days. For example, 8 hours would be converted to
1 day, 12 hours would be converted to 1.5 days, and 18 hours would be converted to 2.25 days.
The class should have a constructor that accepts a number of hours, as well as member
functions for storing and retrieving the hours and days.
The class should also have the following overloaded operators:
• + Addition operator. When two NumDays objects are added together, the
overloaded + operator should return the sum of the two objects’ hours members.
• − Subtraction operator. When one NumDays object is subtracted from another,
the overloaded − operator should return the difference of the two objects’ hours
members.
Get the distinct ids of videos that belong to the following genres.
genre_id genre
201 Comedy
202 Action
203 Thriller
211 Scifi
Note:
Sort the output in the descending order ofvideo_id
Expected Output Format
video_id
Please help
This is the code for Getting all the channel_ids that uploaded at least one video in "AI/ML" or "Robotics" technologies between 2018 and 2021.
SELECT
DISTINCT channel_id
FROM
video
WHERE
video_id >= 1
AND name LIKE '%AI/ML%'
OR name LIKE '%Robotics%'
AND strftime('%Y', published_datetime) BETWEEN "2018"
AND "2021"
GROUP BY
channel_id
ORDER BY
channel_id ASC;
How can I Get all the channel_ids that uploaded at least 20 videos in "AI/ML", "Cyber Security", "Data Science" or "Robotics" technologies between 2018 and 2021.
Example: If a channel publishes 5 videos in AI/ML, 10 videos in Cyber Security and 5 videos in Data Science, consider the channel
select video_content.channelid
FROM quiz.video_content inner join user_details u on quiz.video_id=u.user_id
WHERE count(u.user_id) >= 20 AND name like '%DIY%' OR name LIKE '%Robotics%'
"2018" AND "2021" GROUP BY video_content.channelid
ORDER BY video_content.channelid ASC;
This code is not executed please help
Techworld is a technology training center, providing training to their clients on various technologies.They need to automate the process of allocating instructiors for different courses.An instructor is identified by his/her name and may be skilled in multiple technologies .Assume that the skills of an instructor are stored in an array.
We are going to create class of Matrix. You have to write the definition of the following function given below in the Matrix class. class Matrix{ private: int noOfRows ; int noOfColumns; int ** data; public: Matrix(int noOfRows, int noOfColums); void displayData(); -Matrix(); Matrix(const Matrix & ref);You have to write down the definition of following functions. 1. Matrix(int noOfRows, int noOfColums) 2. void displayData0; 3. -Matrix(); 4.Matrix(const Matrix & ref)
#333702 on Dec 2022