Getting catagory title total number of questions and answers order by number of questions

I have three tables. Which is in at this fiddle, http://sqlfiddle.com/#!9/46dfd6

Which is like this?.

CREATE TABLE `user_answers` (   `id` int(250) NOT NULL,   `question_id` varchar(250) NOT NULL,   `user_id` int(250) NOT NULL,   `answer` text NOT NULL,   `date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;  CREATE TABLE `user_questions` (   `id` varchar(250) NOT NULL,   `user_id` int(250) NOT NULL,   `note_id` int(250) NOT NULL,   `title` text NOT NULL,   `question` text NOT NULL,   `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1;  CREATE TABLE `material_univarcity_list` (   `id` int(100) NOT NULL,   `name` varchar(50) NOT NULL,   `about` mediumtext NOT NULL,   `date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

I want to get a resultant table which has count – Name(Name is from material_univarcity_list) Total number of questions to that particular name. Here id of material_univarcity_list table is the note_id of user_questions and I want total number of answers to that particular catagory here question_id is the id of user_questions. How can I do this?

My expected result is like

no|catagory        |number_of_questions |number_of_answers  1|DBMS 5th sem ISE|            2       | 3 

How can i do this?

Anaconda navigator assistance for dan Dellapia have full answers please and thanks

60 POINTS and is considered a loser when he runs out POINTS After the program has finished, display the total number of rolls of the dice that were made in the entire Game To Program:

The game begins with the player having 20 POINTS The player rolls 2 six sided dice and the sum of faces on the two dice are calculated. That’s called the players POINT. If the POINT is a 7 or 11, the player wins his POINT If the POINT is a 2, 3, or 12, the player loses his point If point is anything else, then the game continues by the player rolling the two dice again and again recording and checking the sum until The player makes his point (the sum of his dice equals his point value) and then he wins the point The player rolls a 7 and then he loses his point The player is considered a winner if he can acquire 60 POINTS and is considered a loser when he runs out of points After the program is finished, display the total number of rolls of the dice that were made in the entire game Please include the entire answer not just have it please and thanks

Spoofed DNS answers ignored by target machine applications

Attacker: Arch Linux

Target: Windows 10

Scenario The attackers launches an ARP spoof attack to redirect all target traffic to the attacker. (This works)

The target sends DNS queries for domain name resolution to the attacker machine. (This works)

The attacker machine listens for this queries and if the query tries to resolve a specific domain (detectportal.firefox.com) sends an spoof DNS answer with the attacker’s ip. For all the other domains the queries are not answered and not even forwarded.

Wireshark on both attacker and target machine confirms the reception of the spoofed dns answers although the applications that triggered the dns resolution seems to ignore this answers and just timeout.

Example on target machine:

ipconfig /flushdns nslookup detectportal.firefox.com DNS request timed out.     timeout was 2 seconds. Server: UnKnown Address: 10.42.0.1  (my gateway ip and the ip being spoofed by the ARP attack)  DNS request timed out.     timeout was 2 seconds.  DNS request timed out.     timeout was 2 seconds.  DNS request timed out.     timeout was 2 seconds.  DNS request timed out.     timeout was 2 seconds. **** Request to UnKnown timed-out 

Wireshark confirms the DNS spoof answers are correct and correlates them to the queries.

Assumption:

I do not compute the ip header checksum nor the udp checksum, just put some value (i.e. 0xdead, 0xbeef, 0xcafe). Could it be the target machine dropping these packets AFTER wireshark picks them?

Different application of arden theorem leads to different answers

So, I have to solve for the following set of equations

$ q_1$ = $ q_1$ a + $ q_2$ b + $ \epsilon$

$ q_2$ = $ q_1$ a + $ q_2$ b + $ q_3$ a

$ q_3$ = $ q_2$ a

There are two ways to do this

I did this

$ q_1$ = $ q_2$ b + $ \epsilon$ + $ q_1$ a

$ q_1$ = ($ q_2$ b + $ \epsilon$ )a* Applying ardens theorem

Now substituting in $ q_2$ the values of $ q_1$ and $ q_3$

$ q_2$ = $ q_2$ ba*a + a*a + $ q_2$ b + $ q_2$ aa

$ q_2$ = a*a + $ q_2$ (ba*a+b+aa)

$ q_2$ = a*a(ba*a+b+aa)* Applying ardens theorem

$ q_2$ = a*a(ba*+aa)*

Now substituting in $ q_3$ , the answer should be

$ q_3$ = a*a(ba*+aa)*a

However, the correct answer is

(a + a(b+aa)*b)*a(b+aa)*a

which can be obtained by first substituting $ q_3$ in $ q_2$ , and then substituting $ q_2$ in $ q_1$ , and finally solving $ q_2$ , $ q_3$ from the obtained regular expression for $ q_1$ .

Can someone tell where I have gone wrong in the above method, or am I applying ardens theorem in the wrong way ?

When calculating PSSUQ scores, what happens with NA answers?

PSSUQ (Post Study System Usability Questionnaire) is a post-task measurement tool which is used to assess system’s usability. Current, third version has 16 statements. Each statement has a likert scale from 1 (strongly agree) to 7 (strongly disagree). Each statement also has NA (not applicable) option.

PSSUQ has an overall score which is calculated by averaging the scores given to statements.

User strongly agrees on every statement, PSSUQ overall score is therefore 1.

PSSUQ also has sub-scales for system usefulness (SysUse), information quality (InfoQual) and interface quality (IntQual). Their scores are calculated as:

  • SysUse: averaging scores of statements 1 to 6
  • InfoQual: averaging scores of statements 7 to 12
  • IntQual: averaging scores of statements 13 to 15.

But how should I handle statements that user thinks are not applicable? Do they get the value 0 or do I just ignore them from the calculation? For example in IntQual which has only three statements if NA gets the value 0:

User strongly agrees on two statements and one statement does not apply, IntQual score is 0,667.

If NA is discarded:

User strongly agrees on two statements and one statement does not apply, IntQual score is 1.

I provide 2 high quality Quora answers for unlimited traffic for $2

Quora answers are the bestway to get both traffic and high-quality backlinks at present. I will provide 2 high-quality relevant Quora answers to bring real traffic to your site. Main Features: Unique and relevant answerAll answer submit manuallyAnchor your keywordsFast deliveryGet 100% targeted traffic for a lifetime and better rank on Google with my service.

by: sreza5142
Created: —
Category: Traffic
Viewed: 214


Promote your website with 50 Quora Answers with contextual link for $25

Quora answers is very important for rank your website.We all know that Quora is one of the most popular site that helps to increase traffic to ones website. I’m doing Q&A related work in Quora for last 5 years inside and outside Seoclerk. So I will do my best to get the most of it in order to get you as much traffic as I can. How does it work?Firstly I will search for questions relevant to your website and then I will post quality answers with contextual link in order to attract visitors to your website. If any of the answers get deleted, just inform me then I will immediately replace it with the New One. Why me?1. My Answers appear LIVE for more than expected time.2. You will get 24 hours support if you face any problem.3. Delivery date and service quality strictly maintenance.My Service:01.All answer are Informative & natural.02.No copy paste.03.All are Clickable backlinks.04.Guaranteed Traffic and Backlinks.05.full report in excel sheet.If you have any questions, Feel free to drop me a message. I’ll reply in a bit!​

by: Shanta96
Created: —
Category: Question/Answer
Viewed: 185