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
A sociologist believes that it costs more than P90,000 with a standard deviation of
P4,500 to raise a child from birth to age one. A random sample of 49 families, each with
a child is selected to see if this figure is correct. The average expenses for these families
reveal a mean of P92,000. Based on these sample data, can it be concluded that the
sociologist is correct in his claim? Use 0.05 level of significance.
Step:
1.State the null and alternative hypothesis
concerning the population mean, "\\mu" and the
type of test to be used
2. Specify the level of significance "\\alpha"
3. State the decision rule.
4. Collect the data and perform calculations.
5. Make a statistical decision.
6. State the conclusion.
Find out whether the following functions are one to one or not
(a) f(x)=3x+4 (b) f(x)=x²+4 (c) h(x)=13x⁵+5 (d) g(x)=x⁴+3 (e) p(x)=1/x+3 (f) f(x) =|2x+5|
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)
Create a calculator for the complex number by creating a class of complex number (with two member variables, required constructor(s) and functions) with overloading all operators in it.(Operators: ++,--,+,-,/,*).
2. We want to keep track of Students studying in university. To do so create a class Students that has the following instance variables Reg_no, Name, Age, Address, Semester, CGPA and Fee. Where address is the object of address class and fee is same for all students.
The Student Class should have default constructor and augmented constructor. You need to write set() method to assign values to the instance variables and a method which can return grade using CGPA. You are required to create two objects of Student class and then display his Data along with grade.
In a charming 19th-century hotel, an old-style elevator is connected to a counterweight by a cable that passes over a rotating disk 1.87m
1.87m in diameter. The elevator is raised and lowered by turning the disk, and the cable does not slip on the rim of the disk but turns with it. Through how many revolutions has the disk turned when it has raised the elevator 3.36m
3.36m between floors?
The __________ of IBM consists primarily of receipts resulting from the sale of its productsand/or services.
Write a class Box with three variables length, width and height. Design suitable constructors, set and get functions. Write the main function and create the different objects of Box class. We want to count the objects of Box class what more you can add in your class to achieve the counting facility. Write the code and display the number of object created so far.