Programming does not always happen smoothly, sometimes a lot of patience, devotion and perseverance are required to solve programming problems and stumbling blocks on your way of creating a new programming solution.While developing an application you might come across a number of programming questions the answers to which are not easy to be found. To spare yourself the trouble, submit your programming questions here and you will get programming answers within the shortest time period.
Describe how and why computer operating system is important for your computer and how categorised in different categorie?
Write the definition of void function that takes as input two parameters of type int, double and string.the functions seta the values of int and double variable to 0 and the value of the string variable to the empty string
In a 2x2 Sudoku puzzle, there are 4 connected 2x2 grids and the objective is to fill the grid with
numbers from the set V = {1, 2, 3, 4}, such that each number appears exactly once in the same grid,
exactly once in any row, and exactly once in any column. Below is a diagram depicting an empty
2x2 Sudoku and a possible solution state.
Write a program that takes an empty 2x2 grid as input and fills it to reach a valid solution state using
backtracking.
Solve this Backtracking Question in C++
A two dimensional array of characters can be considered as a field. Each cell is either water 'W' or
a tree 'T'. A forest is a collection of connected trees. Two trees are connected if they share a side
i.e. if they are adjacent to each other. Your task is, given the information about the field, print the
size of the largest forest. Size of a forest is the number of trees in it. See the sample case for clarity;
Sample Input:
5
TTTWW
TWWTT
TWWTT
TWTTT
WWTTT
Sample Output:
10
Speed Typing Test
In this assignment, let's build a Speed Typing Test by applying the concepts we learned till now.
Refer to the below image.
https://assets.ccbp.in/frontend/content/dynamic-webapps/speed-typing-test-output.gif
The Url will show you the required output to be generated.
Instructions:
By following the above instructions, achieve the given functionality.
Clock Image:
CSS Colors Used:
Background Color Hex Codes Used:
#690cb0
#dac0ff
#f3eaff
#f2ebfe
#ffffff
Border Color Hex Codes Used:
#9aa5b1
Text Color Hex Codes Used:
#690cb0
#3e4c59
#ffffff
#323f4b
Book Search
In this assignment, let's build a Book Search page by applying the concepts we learned till now.
Refer to the below image.
https://assets.ccbp.in/frontend/content/dynamic-webapps/book_search_output.gif
Just for not having the image inserting option in this platform, I am giving the url of the image as that we have to generate.
Instructions:
By following the above instructions, achieve the given functionality.
Use this Background image:
https://assets.ccbp.in/frontend/dynamic-webapps/book-search-bg.png
CSS Colors used:
Text colors Hex code values used:
#323f4b
#ffffff
CSS Font families used:
Rules to be followed:-
please Help me.
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;
Output Table:
channel_id
351
353
364
365
377
But,
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
the table data is very huge so, I cant send the complete table data.
please help me.
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;
Output Table:
channel_id
351
353
364
365
377
But,
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
the table data is very huge so, I cant send the complete table data.
please help me.
Find the sum of durations of the videos published by each channel in hours.
Table: Video
video_id name duration_in_secs published_datetime no_of_views channelid
1002 Victoria Beckham
Gives Strangers
Fashion Advice 836 2021-01-19 20:12 75609 353
for $2 in Central
Park | Vanity Fair
1007 DIY - Simon's Cat
|NEW BLACK & WHITE! 1365 2012-09-07 11:32 106271 355
1008 You, but in emojis.
(YIAY #375) 3874 2021-01-19 20:12 16469 352
1009 100 People Hold
Their Breath for as 2885 2015-05-17 19:32 272102 354
Long as They Can
1010 Luke Bryan - Hooked
On It (Audio) 2106 2016-02-10 12:32 184471 366
1011 The perfect ice -
Ice boats on 2549 2020-07-10 15:32 108047 352
Lake Geneva
1012 5 Days Of Wearing
DIY Makeup | Try 3172 2018-11-05 08:32 178623 358
Living With Lucie
| Refinery29
1013 Idiot's Guide to
Japanese Squat Toilets 709 2009-08-05 11:32 44293 356
1019 Vostok Brompton Beach
Ride 2022 2016-04-05 19:00 204704 367
1020 SHOPPING FOR NEW FISH!! 3496 2021-01-19 20:12 294429 359
1021 Paramore: Fake Happy
[OFFICIAL VIDEO] 1397 2015-07-05 19:00 245138 368
1022 Howard Stern: George
Takei Talks About Harvey
Weinstein and Sexually 776 2021-01-19 20:12 35875 360
Assault
1023 Tony Hawk Answers
Skateboarding Questions 4476 2017-02-17 19:32 143404 354
From Twitter |
Tech Support | WIRED
1024 Kimbra - Top of the
World (Official Music 3243 2015-01-05 19:00 220673 368
Video)
1025 Aly Raisman On Dr.
Larry Nassar’s Medical
Treatment: I Didn’t Know 2978 2014-12-17 19:32 93272 354
It Was Abuse | Megyn Kelly
TODAY
1026 When Someone Has A
Crush on You | Lilly Singh 959 2021-01-19 20:12 139481 360
1051 Demi Lovato - Sorry
Not Sorry in the Live Lounge 3929 2021-01-19 20:12 265864 365
channel_id no_of_hours
... ...
Get all the channel_ids that uploaded at least 5 videos in "AI/ML", "Cyber Security", "Data Science" or "Robotics" technologies between 2018 and 2021.
Example: If a channel publishes 2 videos in AI/ML, 1 videos in Cyber Security and 2 videos in Data Science, consider the channel.
Table: Video
video_id name duration_in_secs published_datetime no_of_views channelid
1002 Victoria Beckham
Gives Strangers
Fashion Advice 836 2021-01-19 20:12 75609 353
for $2 in Central
Park | Vanity Fair
1007 DIY - Simon's Cat
|NEW BLACK & WHITE! 1365 2012-09-07 11:32 106271 355
1008 You, but in emojis.
(YIAY #375) 3874 2021-01-19 20:12 16469 352
1009 100 People Hold
Their Breath for as 2885 2015-05-17 19:32 272102 354
Long as They Can
1010 Luke Bryan - Hooked
On It (Audio) 2106 2016-02-10 12:32 184471 366
1011 The perfect ice -
Ice boats on 2549 2020-07-10 15:32 108047 352
Lake Geneva
1012 5 Days Of Wearing
DIY Makeup | Try 3172 2018-11-05 08:32 178623 358
Living With Lucie
| Refinery29
1013 Idiot's Guide to
Japanese Squat Toilets 709 2009-08-05 11:32 44293 356
1019 Vostok Brompton Beach
Ride 2022 2016-04-05 19:00 204704 367
1020 SHOPPING FOR NEW FISH!! 3496 2021-01-19 20:12 294429 359
1021 Paramore: Fake Happy
[OFFICIAL VIDEO] 1397 2015-07-05 19:00 245138 368
1022 Howard Stern: George
Takei Talks About Harvey
Weinstein and Sexually 776 2021-01-19 20:12 35875 360
Assault
1023 Tony Hawk Answers
Skateboarding Questions 4476 2017-02-17 19:32 143404 354
From Twitter |
Tech Support | WIRED
1024 Kimbra - Top of the
World (Official Music 3243 2015-01-05 19:00 220673 368
Video)
1025 Aly Raisman On Dr.
Larry Nassar’s Medical
Treatment: I Didn’t Know 2978 2014-12-17 19:32 93272 354
It Was Abuse | Megyn Kelly
TODAY
1026 When Someone Has A
Crush on You | Lilly Singh 959 2021-01-19 20:12 139481 360
1051 Demi Lovato - Sorry
Not Sorry in the Live Lounge 3929 2021-01-19 20:12 265864 365
channel_id
...