Programming & Computer Science Answers

Create a class: Doctor, with private data members: id, name, specialization and salary with 

public member function: get_data () to take input for all data members, show_data () to display 

the values of all data members and get_specialization () to return specialization. Write a 

program to write 10 records of doctors and allocating the memory at run time only.

Create a class called ADDITION has one integer and one float data member. Use pointer to 

data member to find their sum and print it from main method and also use the concept of 

dynamic constructor.

Get all the potential users. Fetch the user_ids who liked at least 2 videos published by "Disney" channel, and who did not subscribe to the channel (channel_id = 352).

Note:

• Consider reaction_type LIKE as liked.
• Sort the output in the descending order of no_of_likes, and then in the ascending order of potential_user_id.

Expected Output Format

potential_user_idno_of_likes

sir plz explain the sql query

Get all the user_ids who liked at least 5 videos published by "Tedx" channel.

Note:

• Consider reaction_type LIKE as liked.
• Sort the output in the descending order of no_of_likes, and then in the ascending order of active_user_id.

Expected Output Format

active_user_idno_of_likes

sir plz explain the sql query

Best time to upload a comedy video:

DunkFest channel is planning to upload a video in the "COMEDY" genre

Give the channel the best suitable hour of the day when users positively engage more with comedy videos.

Note:

• Consider positive engagement as LIKE for the videos in the "COMEDY" genre_type.
• Consider reaction_type LIKE as liked.
• Return the hour in the integer format

Expected Output Format

hour_of_engagementno_of_likes5

sir plz explain sql query

Get all the distinct user_ids who liked at least one video uploaded by Android Authority Channel (channel__id = 364) but didn't like the video uploaded by Tech savvy channel with video_id = 1005.

Note:

• Consider reaction_type LIKE as liked
• Sort the output in the ascending order of user_id.

Expected Output Format

user_id

sir plz explain sql query

Write a program with analysis to sort in descending manner using 'p' number of values and analyze the complexity.

Sum of Prime Numbers In the Input

Given a list of integers, write a program to print the sum of all prime numbers in the list of integers.

Note: One is neither prime nor composite number.Input

The input will be a single line containing space-separated integers..Output

The output should be a single line containing the sum of all prime numbers from 1 to N.Explanation

For example, if the given list of integers are

2 4 5 6 7 3 8

As 2, 3, 5 and 7 are prime numbers, your code should print the sum of these numbers. So the output should be 17.

Sample Input 1

2 4 5 6 7 3 8

Sample Output 1

17

Sample Input 2

65 87 96 31 32 86 57 69 20 42

Sample Output 2

31

Mean, Median and Mode

Given a list of integers, write a program to print the mean, median and mode.

Mean - The average value of all the numbers.

Median - The mid point value in the sorted list.

Mode - The most common value in the list. If multiple elements with same frequency are present, print all the values with same frequency in increasing order.

Input

The input will be a single line containing space-separated integers.Output

The first line of output should contain the mean, round off the value to 2 decimal places.

The second line of output should contain the median, round off the value to 2 decimal places.

The third line of output should contain the mode.

Mean should always be a float value.

Median should be a float value when there are even number of elements, otherwise should be an integer value.

Sample Input 1

2 4 5 6 7 8 2 4 5 2 3 8

Sample Output 1

Mean: 4.67

Median: 4.5

Mode: 2

Sample Input 2

2 6 3 1 8 12 2 9 10 3 4

Sample Output 2

Mean: 5.45

Median: 4

Mode: 2 3

Mrkq#6=49#Dpsolilhg#Eleoh#+DPS,#%Iru#Jrg#vr#^juhdwo|`#oryhg#dqg#ghduo|#sul}hg#wkh#zruog/#wkdw#Kh#^hyhq`#jdyh#Klv#^Rqh#dqg`#^d`rqo|#ehjrwwhq#Vrq/#vr#wkdw#zkrhyhu#eholhyhv#dqg#wuxvwv#lq#Klp#^dv#Vdylru`#vkdoo#qrw#shulvk/#exw#kdyh#hwhuqdo#olih1

Copy this text and save it to a text file.

Write a C++ program that does the following:

Creates a class called Paragraph.  It will have one private member variable of type string.

Opens the text file and reads in the text and stores it in an instance of “Paragraph”.

Decode the message by subtracting 3 from the ASCII value for each character (For example, ‘M’ becomes ‘J’, and ‘#’ becomes a space character).

Store the decoded message in another instance of “Paragraph”.

Output the decoded message to another text file.

If this is done successfully, you will see an English, decoded message in the new text file.

Please follow all instructions