#include <stdio.h> #include <sys/socket.h> #include <netinet/in.h> #include <unistd.h> #include <sys/time.h> #include <arpa/inet.h> #include <string.h> #include <time.h> int main() { int server_sockfd, client_sockfd; int server_len, client_len; char msg1[100]; time_t t; struct sockaddr_in server_address, client_address; // Create a TCP socket server_sockfd = socket(AF_INET, SOCK_STREAM, 0); if (server_sockfd < 0) { perror("Error in socket creation"); return 1; } // Initialize server address struct server_address.sin_family = AF_INET; server_address.sin_port = htons(4006); // Convert port to network byte order server_address.sin_addr.s_addr = htonl(INADDR_ANY); server_len = sizeof(server_ad...
Posts
70) The courier manager wants to find the details of the courier whose cost is greater than the average cost of the courier in that branch. Write a query to display courier details like courier id, to address and weight of the couriers. Sort the results based on the to address in ascending and weight in ascending order.
69) The courier manager decides to create a new courier code for the courier which was booked after '31-03-2020'. The courier code should be created by adding the first three letters of the from address, followed by the first two letters of the courier id and the first three letters of the to address. The courier code should be in upper case. Write a query to display courier details like courier id, branch id and courier code. Give an alias name for the courier code as 'COURIER_CODE'. Sort the results based on the booking date in ascending order.
67) Write a single query to update the courier's cost based on the following conditions: If the weight of the courier is less than 5 kg, then increase the cost by 5%. If the weight of the courier is greater than or equal to 5 kg and less than or equal to 10 kg, then increase the cost by 10%. If the weight of the courier is greater than 10 kg, then increase the cost by 15%.
